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 -N -r1.13 -r1.13.2.1 --- openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql 7 Aug 2017 23:47:56 -0000 1.13 +++ openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql 12 Apr 2020 08:52:42 -0000 1.13.2.1 @@ -269,6 +269,7 @@ 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_rel_type_idx on group_element_index (rel_type); +create index group_elem_idx_container_idx on group_element_index(container_id); -- The index on container_id is not very good -- and in some cases can be quite detrimental