Index: openacs-4/packages/ams/sql/postgresql/ams-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ams/sql/postgresql/ams-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/ams/sql/postgresql/ams-create.sql	9 Feb 2006 20:46:42 -0000	1.9
+++ openacs-4/packages/ams/sql/postgresql/ams-create.sql	16 May 2006 06:21:16 -0000	1.10
@@ -155,6 +155,7 @@
 );
 
 create index ams_attribute_values_attribute_idx on ams_attribute_values(attribute_id);
+create index ams_attribute_values_attribute_object_idx on ams_attribute_values(object_id,attribute_id);
 
 ------ Options
 --------------------------------------------------------------------
