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.4 -r1.5
--- openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	21 Feb 2005 14:32:55 -0000	1.4
+++ openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	16 Oct 2006 13:17:04 -0000	1.5
@@ -125,7 +125,7 @@
 create index as_item_data_pk2 on as_item_data (session_id, section_id, as_item_id);
 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 table as_session_results (
        result_id   integer
                    constraint as_sess_res_res_id_pk
