Index: openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql,v
diff -u -r1.22 -r1.23
--- openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql	13 Feb 2009 13:36:02 -0000	1.22
+++ openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql	14 Feb 2009 02:51:38 -0000	1.23
@@ -152,7 +152,6 @@
 );
 
 create index acs_objects_context_object_idx on acs_objects (context_id, object_id);
-create index acs_obj_ctx_idx_object_id_idx on acs_object_context_index (object_id);
 
 alter table acs_objects modify constraint acs_objects_context_object_un enable;
 
@@ -242,6 +241,7 @@
 ) organization index;
 
 create index acs_obj_ctx_idx_ancestor_idx on acs_object_context_index (ancestor_id);
+create index acs_obj_ctx_idx_object_id_idx on acs_object_context_index (object_id);
 
 create or replace view acs_object_paths
 as select object_id, ancestor_id, n_generations