Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.8.3d1-5.8.3d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.8.3d1-5.8.3d2.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.8.3d1-5.8.3d2.sql	27 Apr 2015 15:28:17 -0000	1.2
@@ -0,0 +1,6 @@
+
+drop index site_nodes_parent_id_idx;
+create index site_nodes_parent_object_node_id_idx on site_nodes(parent_id, object_id, node_id);
+create index site_nodes_parent_id_idx on site_nodes(parent_id);
+create index site_node_object_mappings_node_id_idx on site_node_object_mappings(node_id);
+
