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.19 -r1.20
--- openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql	9 Sep 2008 17:28:22 -0000	1.19
+++ openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql	27 Apr 2015 15:28:19 -0000	1.20
@@ -81,6 +81,8 @@
 );
 
 create index as_item_choices_sort_order_idx on as_item_choices (mc_id, sort_order);
+create index as_item_choices_content_value_idx on as_item_choices(content_value);
+create index as_item_choices_mc_id_idx on as_item_choices(mc_id);
 
 -- Short Answer Answers
 create table as_item_sa_answers (
