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.*
