Index: openacs-4/packages/acs-kernel/acs-kernel.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v
diff -u -N -r1.150.2.24 -r1.150.2.25
--- openacs-4/packages/acs-kernel/acs-kernel.info	14 Mar 2020 19:01:42 -0000	1.150.2.24
+++ openacs-4/packages/acs-kernel/acs-kernel.info	12 Apr 2020 08:52:42 -0000	1.150.2.25
@@ -9,15 +9,15 @@
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
 
-    <version name="5.10.0d27" url="http://openacs.org/repository/download/apm/acs-kernel-5.10.0d27.apm">
+    <version name="5.10.0d28" url="http://openacs.org/repository/download/apm/acs-kernel-5.10.0d28.apm">
         <owner url="mailto:oct@openacs.org">OpenACS Core Team</owner>
         <summary>Routines and data models providing the foundation for OpenACS-based Web services.</summary>
         <release-date>2017-08-06</release-date>
         <vendor url="http://openacs.org">OpenACS</vendor>
         <description format="text/html">The OpenACS kernel contains the core datamodel create and drop scripts for such things as objects, groups, parties and the supporting PL/SQL and PL/pgSQL procedures.</description>
         <maturity>3</maturity>
 
-        <provides url="acs-kernel" version="5.10.0d27"/>
+        <provides url="acs-kernel" version="5.10.0d28"/>
 
         <callbacks>
         </callbacks>
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
Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.10.0d27-5.10.0d28.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/Attic/upgrade-5.10.0d27-5.10.0d28.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.10.0d27-5.10.0d28.sql	12 Apr 2020 08:52:42 -0000	1.1.2.1
@@ -0,0 +1,4 @@
+--
+-- create index since column is used as foreign key
+--
+CREATE INDEX group_elem_idx_container_idx ON group_element_index(container_id);
Index: openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql,v
diff -u -N -r1.29 -r1.29.2.1
--- openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql	7 Aug 2017 23:47:56 -0000	1.29
+++ openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql	12 Apr 2020 08:52:42 -0000	1.29.2.1
@@ -319,7 +319,9 @@
 -- see http://openacs.org/forums/message-view?message_id=142769
 -- create index group_elem_idx_container_idx on group_element_index (container_id);
 
+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.
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0d27-5.10.0d28.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/Attic/upgrade-5.10.0d27-5.10.0d28.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0d27-5.10.0d28.sql	12 Apr 2020 08:52:42 -0000	1.1.2.1
@@ -0,0 +1,4 @@
+--
+-- create index since column is used as foreign key
+--
+CREATE INDEX IF NOT EXISTS group_elem_idx_container_idx ON group_element_index(container_id);