Rem drv: <create type="indexes"/>
Rem
Rem $Header: data_propagation_indexes.sql 30-jun-2005.14:34:26 rzazueta Exp $
Rem
Rem data_propagation_indexes.sql
Rem
Rem Copyright (c) 2003, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      data_propagation_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    rzazueta    06/20/05 - Add index to mgmt_update_operations_details
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    rzazueta    09/01/04 - Add support for templates 
Rem    rzazueta    07/18/03 - Replace emd_url with agent_guid
Rem    rzazueta    06/18/03 - Move primary key constraints to indexes file
Rem    rzazueta    06/12/03 - rzazueta_propagate_target_data
Rem    rzazueta    06/12/03 - Created
Rem


Rem
Rem Indexes for MGMT_UPDATE_OPERATIONS table
Rem
ALTER TABLE MGMT_UPDATE_OPERATIONS 
    ADD CONSTRAINT PK_MGMT_UPDATE_OPS 
        PRIMARY KEY (operation_guid);

Rem
Rem Indexes for MGMT_UPDATE_OPERATIONS_DATA table
Rem
ALTER TABLE MGMT_UPDATE_OPERATIONS_DATA 
    ADD CONSTRAINT PK_MGMT_UPD_OPS_DATA 
        PRIMARY KEY (data_set_guid);

Rem
Rem Indexes for MGMT_UPDATE_OPERATIONS_DETAILS table
Rem
ALTER TABLE MGMT_UPDATE_OPERATIONS_DETAILS 
    ADD CONSTRAINT PK_MGMT_UPDATE_OPS_DETAILS 
        PRIMARY KEY (operation_guid, destination_target_guid, agent_guid);

CREATE INDEX MGMT_UPDATE_OPS_DETAILS_IDX01
  ON MGMT_UPDATE_OPERATIONS_DETAILS(destination_target_guid);

CREATE INDEX MGMT_UPDATE_OPS_DETAILS_IDX02
  ON MGMT_UPDATE_OPERATIONS_DETAILS(execution_id, destination_target_guid, execution_status);

CREATE INDEX MGMT_UPDATE_OPS_DETAILS_IDX03
  ON MGMT_UPDATE_OPERATIONS_DETAILS(execution_id, execution_status);

Rem
Rem Indexes for MGMT_UPDATE_THRESHOLDS_DATA table
Rem
ALTER TABLE MGMT_UPDATE_THRESHOLDS_DATA 
    ADD CONSTRAINT PK_MGMT_UPD_THRES_DATA
        PRIMARY KEY (data_set_guid, metric_guid, coll_name, key_value);

Rem
Rem Indexes for MGMT_UPDATE_PROPERTIES_DATA table
Rem
ALTER TABLE MGMT_UPDATE_PROPERTIES_DATA 
    ADD CONSTRAINT PK_MGMT_UPD_PROP_DATA
        PRIMARY KEY (data_set_guid, property_name, property_type);

Rem
Rem Indexes for MGMT_UPDATE_CREDENTIALS_DATA table
Rem
ALTER TABLE MGMT_UPDATE_CREDENTIALS_DATA 
    ADD CONSTRAINT PK_MGMT_UPD_CRED_DATA
        PRIMARY KEY (data_set_guid, credential_set_name, credential_column);

Rem
Rem Indexes for MGMT_UPDATE_TEMPLATE_DATA_MAP table
Rem
ALTER TABLE MGMT_UPDATE_TEMPLATE_DATA_MAP
    ADD CONSTRAINT PK_MGMT_UPD_TEMPLATE_DATA
        PRIMARY KEY(data_set_guid);