Rem
Rem $Header: service_level_indexes.sql 27-jul-2005.06:02:28 tjana Exp $
Rem
Rem service_level_indexes.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      service_level_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    tjana       07/27/05 - removing create indexes for upgrade 
Rem    gsbhatia    06/26/05 - New repmgr header impl 
Rem    mkm         06/03/05 - mkm_t0519
Rem    mkm         06/02/05 - Created
Rem

SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100

rem
rem  Index for MGMT_SL_RULES table
rem    target_guid will be the primary key
rem

ALTER TABLE MGMT_SL_RULES
   ADD CONSTRAINT sla_rule_pk
       PRIMARY KEY (target_guid)
       USING INDEX STORAGE
                (FREELISTS 4)
                INITRANS 4;

rem
rem  Index for MGMT_SL_METRICS table
rem    target_guid,metric_guid,key_value combination will be the PK
rem

ALTER TABLE MGMT_SL_METRICS
   ADD CONSTRAINT sla_metric_pk
       PRIMARY KEY (target_guid,metric_guid,key_value)
       USING INDEX STORAGE
                (FREELISTS 4)
                INITRANS 4;