Index: openacs-4/packages/acs-kernel/sql/oracle/acs-permissions-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-permissions-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/acs-kernel/sql/oracle/acs-permissions-create.sql 7 May 2001 05:18:15 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/oracle/acs-permissions-create.sql 11 May 2001 00:14:48 -0000 1.3 @@ -52,7 +52,8 @@ primary key (privilege, child_privilege) ); -create bitmap index acs_priv_hier_child_priv_idx on acs_privilege_hierarchy (child_privilege); +-- create bitmap index acs_priv_hier_child_priv_idx on acs_privilege_hierarchy (child_privilege); +create index acs_priv_hier_child_priv_idx on acs_privilege_hierarchy (child_privilege); --create table acs_privilege_method_rules ( -- privilege not null constraint acs_priv_method_rules_priv_fk @@ -205,7 +206,8 @@ ); create index acs_permissions_grantee_idx on acs_permissions (grantee_id); -create bitmap index acs_permissions_privilege_idx on acs_permissions (privilege); +-- create bitmap index acs_permissions_privilege_idx on acs_permissions (privilege); +create index acs_permissions_privilege_idx on acs_permissions (privilege); create or replace view acs_privilege_descendant_map as select p1.privilege, p2.privilege as descendant