Index: openacs-4/packages/dotlrn/sql/oracle/communities-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/communities-create.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/dotlrn/sql/oracle/communities-create.sql	31 May 2002 06:23:49 -0000	1.6
+++ openacs-4/packages/dotlrn/sql/oracle/communities-create.sql	7 Jun 2002 04:45:44 -0000	1.7
@@ -89,6 +89,9 @@
     max_child_sortkey           raw(3)
 );
 
+create index dtlrn_com_all_com_parent_id_idx on dotlrn_communities_all (community_id, parent_community_id;
+create index dtlrn_com_all_archived_p_idx on dotlrn_communities_all (archived_p);
+
 create or replace view dotlrn_communities
 as
     select dotlrn_communities_all.*
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.40 -r1.41
--- openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	24 May 2002 01:58:46 -0000	1.40
+++ openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	7 Jun 2002 04:42:49 -0000	1.41
@@ -244,6 +244,8 @@
 	value			varchar(200) 
 );
 
+create index p_element__prms_elem_id_idx on portal_element_parameters (element_id);
+create index p_element_prms_elem_key_idx on portal_element_parameters (element_id, key);
 
 -- 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