Index: openacs-4/packages/acs-kernel/sql/postgresql/rel-constraints-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/rel-constraints-create.sql,v
diff -u -r1.10 -r1.11
--- openacs-4/packages/acs-kernel/sql/postgresql/rel-constraints-create.sql	20 Apr 2001 04:29:21 -0000	1.10
+++ openacs-4/packages/acs-kernel/sql/postgresql/rel-constraints-create.sql	20 Apr 2001 18:04:01 -0000	1.11
@@ -534,6 +534,9 @@
 	unique (rel_segment, rel_side, required_rel_segment)
 );
 
+create index rc_segment_required_seg_idx on 
+rc_segment_required_seg_map(required_rel_segment);
+
 create function rel_constraints_ins_tr () returns opaque as '
 declare
         v_rec   record;