Index: openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql,v
diff -u -r1.12 -r1.13
--- openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	10 Oct 2009 22:38:09 -0000	1.12
+++ openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	27 Apr 2015 15:28:18 -0000	1.13
@@ -148,7 +148,13 @@
 create index as_item_data_pk3 on as_item_data (as_item_id, section_id, session_id);
 create index as_item_data_subj_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);
 
+
+
 create or replace trigger as_item_data_ins_trg
 before insert on as_item_data
 for each row