Rem drv: <create type="indexes" pos="jobs/jobs_indexes.sql+"/>
Rem
Rem $Header: rep_metric_indexes.sql 29-jun-2005.01:48:24 gsbhatia Exp $
Rem
Rem rep_metric_indexes.sql
Rem
Rem Copyright (c) 2002, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      rep_metric_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    pmodi      06/17/05 - Bug:4305824- Index on 
Rem                          mgmt_metric_dependency_details 
Rem    pmodi      04/15/05 - added index for mgmt_metric_dependency 
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    streddy    04/09/03 - streddy_composite_target_availability
Rem    streddy    04/08/03 - Created
Rem

Rem
Rem Indices for MGMT_METRICS table
Rem


Rem
Rem Indices for MGMT_METRIC_DEPENDENCY_DETAILS
Rem
CREATE INDEX MGMT_METRIC_DEP_DETAILS_IDX_01 ON
   MGMT_METRIC_DEPENDENCY_DETAILS (DEP_TARGET_GUID, DEP_METRIC_GUID, DEP_KEY_VALUE);

Rem
Rem Indices for MGMT_METRIC_DEPENDENCY
Rem
CREATE INDEX MGMT_METRIC_DEPENDENCY_IDX_01 ON
   MGMT_METRIC_DEPENDENCY (TARGET_GUID);


Rem
Rem Creating Index on edep_target_guid
Rem

CREATE INDEX MGMT_METRIC_DEP_DETAILS_IDX_02 ON 
  MGMT_METRIC_DEPENDENCY_DETAILS (EDEP_TARGET_GUID);