Rem
Rem $Header: group_comp_indexes.sql 08-feb-2005.12:53:04 gsbhatia Exp $
Rem
Rem group_comp_indexes.sql
Rem
Rem Copyright (c) 2002, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      group_comp_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    02/08/05 - Removing header 
Rem    ktlaw       01/11/05 - add repmgr header 
Rem    tjaiswal    10/16/03 - tjaiswal_ocs_comp_bugs 
Rem    tjaiswal    08/05/03 - Created
Rem

Rem
Rem Indices for MET_SEV_BLKOUT table
Rem

ALTER TABLE MET_SEV_BLKOUT
   ADD CONSTRAINT sev_primary_key
       PRIMARY KEY (target_guid, metric_guid, key_value, blkout_timestamp)
       USING INDEX STORAGE
                (FREELISTS 4)
                INITRANS 4;