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.71.2.3 -r1.71.2.4 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql 3 Sep 2019 09:09:16 -0000 1.71.2.3 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql 15 Nov 2019 14:43:09 -0000 1.71.2.4 @@ -253,7 +253,9 @@ -- create index acs_objects_context_object_idx onacs_objects (context_id, object_id); create index acs_objects_creation_user_idx on acs_objects (creation_user); +create index acs_objects_creation_date_idx on acs_objects (creation_date); create index acs_objects_modify_user_idx on acs_objects (modifying_user); +create index acs_objects_last_modified_idx on acs_objects (last_modified); create index acs_objects_package_idx on acs_objects (package_id); create index acs_objects_title_idx on acs_objects(title);