Index: openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql 20 Mar 2001 22:51:55 -0000 1.1 +++ openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql 11 May 2001 00:14:48 -0000 1.2 @@ -54,10 +54,14 @@ check (min_n_rels_two <= max_n_rels_two) ); -create bitmap index acs_rel_types_objtypeone_idx on acs_rel_types (object_type_one); -create bitmap index acs_rel_types_role_one_idx on acs_rel_types (role_one); -create bitmap index acs_rel_types_objtypetwo_idx on acs_rel_types (object_type_two); -create bitmap index acs_rel_types_role_two_idx on acs_rel_types (role_two); +-- create bitmap index acs_rel_types_objtypeone_idx on acs_rel_types (object_type_one); +create index acs_rel_types_objtypeone_idx on acs_rel_types (object_type_one); +-- create bitmap index acs_rel_types_role_one_idx on acs_rel_types (role_one); +create index acs_rel_types_role_one_idx on acs_rel_types (role_one); +-- create bitmap index acs_rel_types_objtypetwo_idx on acs_rel_types (object_type_two); +create index acs_rel_types_objtypetwo_idx on acs_rel_types (object_type_two); +-- create bitmap index acs_rel_types_role_two_idx on acs_rel_types (role_two); +create index acs_rel_types_role_two_idx on acs_rel_types (role_two); comment on table acs_rel_types is ' Each row in acs_rel_types represents a type of