Rem drv: <create type="indexes"/>
Rem
Rem $Header: preferences_indexes.sql 29-jun-2005.01:48:34 gsbhatia Exp $
Rem
Rem preferences_indexes.sql
Rem
Rem Copyright (c) 2002, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      preferences_indexes.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    gsbhatia    06/26/05 - New repmgr header impl 
Rem    jpyang      05/05/05 - add index on MGMT_USER_FOLDERS 
Rem    lgloyd      03/23/05 - remove portlets 
Rem    gsbhatia    02/13/05 - updating repmgr header 
Rem    gsbhatia    02/09/05 - updating repmgr header 
Rem    gsbhatia    02/07/05 - updating repmgr header 
Rem    ktlaw       01/11/05 - add repmgr header 
Rem    asawant     09/14/04 - Adding columns to MGMT_USER_TYPE_METRIC_PREFS 
Rem    rpinnama    05/14/02 - rpinnama_reorg_rep_scripts
Rem    rpinnama    05/14/02 - Created
Rem


Rem
Rem Indices for MGMT_USER_SUBTAB_COL_PREFS table
Rem
ALTER TABLE MGMT_USER_SUBTAB_COL_PREFS
   ADD CONSTRAINT user_subtab_col_prefs_pk
       PRIMARY KEY (user_name, subtab_name, display_order)
       USING INDEX;


Rem
Rem Indices for MGMT_USER_PREFERENCES table
Rem
ALTER TABLE MGMT_USER_PREFERENCES
   ADD CONSTRAINT user_preferences_primary_key
       PRIMARY KEY (user_name, preference_name)
       USING INDEX;

CREATE INDEX MGMT_USER_FOLDERS_IDX01 ON MGMT_USER_FOLDERS(TARGET_GUID);