Index: openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql,v
diff -u -r1.48.2.2 -r1.48.2.3
--- openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	15 Aug 2019 10:31:02 -0000	1.48.2.2
+++ openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	23 Nov 2020 15:49:52 -0000	1.48.2.3
@@ -86,6 +86,8 @@
     value                           varchar(200)
 );
 
+create index portal_datasource_def_params_datasource_id_idx on portal_datasource_def_params(datasource_id);
+
 -- Layouts are ADP templates for the portal page. i.e. 2 cols, 3 cols,
 -- etc. They are globally available. No secret layouts!
 create table portal_layouts (
@@ -238,6 +240,9 @@
     unique (page_id, pretty_name)
 );
 
+create index portal_element_map_datasource_id_idx on portal_element_map(datasource_id);
+create index portal_element_map_page_id_idx on portal_element_map(page_id);
+
 create table portal_element_parameters (
     parameter_id                    integer
                                     constraint portal_element_parameters_pk
@@ -266,6 +271,8 @@
 );
 
 create index p_element_prms_elem_key_idx on portal_element_parameters (element_id, key);
+create index portal_element_parameters_element_id_idx on portal_element_parameters(element_id);
+create index portal_element_parameters_value_idx on portal_element_parameters(value);
 
 -- This table maps the datasources that are available for portals to
 -- bind to (i.e. creating a PE). This table is required since some DSs