Index: openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql,v
diff -u -r1.14 -r1.15
--- openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql	5 Jan 2005 12:39:28 -0000	1.14
+++ openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql	23 Jan 2005 18:10:48 -0000	1.15
@@ -72,6 +72,8 @@
 			check (percent_score <= 100)	
 );
 
+create index as_item_choices_sort_order_idx on as_item_choices (mc_id, sort_order);
+
 -- Short Answer Answers
 create table as_item_sa_answers (
 	choice_id       integer
