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.7 -r1.8
--- openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql	30 Sep 2003 12:10:02 -0000	1.7
+++ openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql	11 Dec 2003 21:39:51 -0000	1.8
@@ -257,9 +257,14 @@
 create index group_elem_idx_group_idx on group_element_index (group_id);
 create index group_elem_idx_element_idx on group_element_index (element_id);
 create index group_elem_idx_rel_id_idx on group_element_index (rel_id);
-create index group_elem_idx_container_idx on group_element_index (container_id);
 create index group_elem_idx_rel_type_idx on group_element_index (rel_type);
 
+-- The index on container_id is not very good
+-- and in some cases can be quite detrimental
+-- see http://openacs.org/forums/message-view?message_id=142769
+-- create index group_elem_idx_container_idx on group_element_index (container_id);
+
+
 comment on table group_element_index is '
  This table is for internal use by the parties system.  It as an auxiliary
  table, a denormalization of data, that is used to improve performance.