Rem
Rem $Header: storage_common_indexes.sql 29-jun-2005.01:48:45 gsbhatia Exp $
Rem
Rem common_indexes.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      common_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    ajdsouza    04/24/05 - Added additional indexes
Rem                           index MGMT_STORAGE_REP_ALIAS_IDX02
Rem                           MGMT_STORAGE_REP_DATA_IDX02|03
Rem    ajdsouza    03/25/05 - moved from latest
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    ajdsouza    08/10/04 - ajdsouza_ecm_processing
Rem    ajdsouza    07/30/04 - ajdsouza_fix_storage_metrics
Rem    ajdsouza    07/28/04 - Created
Rem

CREATE INDEX MGMT_STORAGE_REP_DATA_IDX02 ON MGMT_STORAGE_REPORT_DATA( ECM_SNAPSHOT_ID, STORAGE_LAYER, ENTITY_TYPE )
/
CREATE INDEX MGMT_STORAGE_REP_DATA_IDX03 ON MGMT_STORAGE_REPORT_DATA( STORAGE_LAYER, ENTITY_TYPE )
/
CREATE INDEX MGMT_STORAGE_REP_DATA_IDX04 ON MGMT_STORAGE_REPORT_DATA( GLOBAL_UNIQUE_ID )
/
CREATE UNIQUE INDEX MGMT_STORAGE_REP_ALIAS_IDX02 ON MGMT_STORAGE_REPORT_ALIAS( VALUE, KEY_VALUE, ECM_SNAPSHOT_ID )
/