Index: openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql	23 Feb 2002 02:43:45 -0000	1.2
+++ openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql	29 Mar 2002 17:12:10 -0000	1.3
@@ -34,6 +34,8 @@
                                               'banned', 'rejected', 'deleted'))
 );
 
+create index member_rels_member_state_idx on membership_rels (member_state);
+
 declare
   attr_id acs_attributes.attribute_id%TYPE;
 begin
