Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql,v diff -u -r1.57 -r1.58 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql 17 Sep 2007 09:43:56 -0000 1.57 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql 13 Feb 2009 13:36:02 -0000 1.58 @@ -411,6 +411,7 @@ ); 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 view acs_object_paths as select object_id, ancestor_id, n_generations