Rem drv: <create type="indexes"/>
Rem
Rem $Header: collections_indexes.sql 15-sep-2005.23:01:07 jsadras Exp $
Rem
Rem collections_indexes.sql
Rem
Rem Copyright (c) 2002, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      collections_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    jsadras     09/15/05 - remove index on 
Rem                           mgmt_collection_tasks.error_message 
Rem    pmodi       09/10/05 - Bug:4593645 -Add index on 
Rem                           mgmt_collection_tasks.error_message 
Rem    gsbhatia    06/26/05 - New repmgr header impl 
Rem    jsadras     06/08/05 - add index on next_collection_time 
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    rpinnama    09/13/04 - Remove indexes on mgmt_collection_metrics and 
Rem                           mgmt_metric_thresholds 
Rem    rpinnama    09/10/04 - Remove the uniquemess on mgmt_coll_metric_tasks_idx_01
Rem    jsadras     08/03/04 - remove mgmt_collection_tasks_idx02 
Rem    rpinnama    06/17/04 - Add indices for repos collection tables 
Rem    lgloyd      11/06/03 - perf: mgmt_metric_collections_rep 
Rem    rpinnama    05/14/02 - rpinnama_reorg_rep_scripts
Rem    rpinnama    05/14/02 - Created
Rem


Rem
Rem Indices for MGMT_METRIC_COLLECTIONS_REP table
Rem
ALTER TABLE MGMT_METRIC_COLLECTIONS_REP
   ADD CONSTRAINT mgmt_metric_collections_rep_pk
       PRIMARY KEY (target_guid, metric_guid, coll_name)
       USING INDEX;


Rem
Rem Indices for mgmt_collections table
Rem

ALTER TABLE mgmt_collections
  ADD CONSTRAINT mgmt_collections_pk
    PRIMARY KEY (object_guid, coll_name) ; 

Rem
Rem Indices on mgmt_collection_tasks table
Rem
ALTER TABLE mgmt_collection_tasks
  ADD CONSTRAINT  mgmt_collection_tasks_pk
    PRIMARY KEY (task_id)  ;


CREATE INDEX mgmt_collection_tasks_idx01
  ON mgmt_collection_tasks
 (next_collection_timestamp) ;

Rem 
Rem No index on task_status for now to benefit
Rem repo collections performance at tha cost of verify jobs
Rem

Rem
Rem Indices for mgmt_collection_metric_tasks
Rem
CREATE INDEX mgmt_coll_metric_tasks_idx_01
  ON mgmt_collection_metric_tasks
     (task_id, target_guid) ;