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 -N -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
Index: openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql,v
diff -u -N -r1.14 -r1.15
--- openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql	9 Dec 2001 04:21:58 -0000	1.14
+++ openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql	7 Jun 2002 04:21:40 -0000	1.15
@@ -59,6 +59,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 index site_nodes_tree_skey_idx on site_nodes (tree_sortkey);
 
 create function site_node_get_tree_sortkey(integer) returns varbit as '