Index: openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql	20 Mar 2001 22:51:56 -0000	1.1
+++ openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql	7 Jun 2002 04:17:08 -0000	1.2
@@ -47,6 +47,7 @@
 );
 
 create index site_nodes_object_id_idx on site_nodes (object_id);
+create index site_nodes_parent_id_idx on site_nodes(parent_id,object_id,node_id);
 
 create or replace package site_node
 as