Database Conversion
Modifications have been made to the indexes on the Grouper tables for the 1.2.1 release of Grouper. Below you will find a description of each change and an example SQL statement for Oracle that you may execute to make the modification in your database.
For your convenience, we have also included SQL scripts that contain all of these index modifications described below.
Modifications to indexes:
- Drop the concatenated index on grouper_memberships with columns list_name and list_type.
No Format drop index membership_field_idx;
- Drop the index on grouper_memberships.owner_id.
No Format drop index membership_owner_idx;
- Drop the index on grouper_memberships.mship_type.
No Format drop index membership_type_idx;
- Create a concatenated index on grouper_memberships using the columns member_id, list_name, and list_type.
No Format create index membership_member_list_idx on grouper_memberships (member_id, list_name, list_type);
- Create a concatenated index on grouper_memberships using the columns owner_id, list_name, list_type, and mship_type.
No Format create index membership_owner_list_type_idx on grouper_memberships (owner_id, list_name, list_type, mship_type);