Index: openacs-4/packages/assessment/sql/postgresql/assessment-types-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-types-create.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/assessment/sql/postgresql/assessment-types-create.sql	15 May 2007 20:14:16 -0000	1.5
+++ openacs-4/packages/assessment/sql/postgresql/assessment-types-create.sql	27 Apr 2015 15:28:19 -0000	1.6
@@ -58,3 +58,7 @@
 	constraint as_item_rels_pk
 	primary key (item_rev_id, rel_type, target_rev_id)
 );
+
+create index as_item_rels_item_rev_id_idx on as_item_rels(item_rev_id);
+create index as_item_rels_target_rev_id_idx on as_item_rels(target_rev_id);
+