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.10 -r1.11
--- openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	12 Jun 2006 02:49:50 -0000	1.10
+++ openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	16 Oct 2006 13:17:04 -0000	1.11
@@ -126,6 +126,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_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 table as_session_results (
        result_id   integer
