Index: openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql,v diff -u -r1.20 -r1.21 --- openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql 27 Oct 2014 16:40:56 -0000 1.20 +++ openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql 27 Apr 2015 15:28:19 -0000 1.21 @@ -146,6 +146,10 @@ create index as_item_data_pk3 on as_item_data (as_item_id, section_id, session_id); create index as_item_data_subject_id_idx on as_item_data (subject_id); create index as_item_data_as_item_id_idx on as_item_data (as_item_id); +create index as_item_data_content_answer_idx on as_item_data(content_answer); +create index as_item_data_file_id_idx on as_item_data(file_id); +create index as_item_data_section_id_idx on as_item_data(section_id); +create index as_item_data_staff_id_idx on as_item_data(staff_id);