Rem drv: <create type="indexes"/>
Rem
Rem $Header: trace_indexes.sql 29-jun-2005.01:48:39 gsbhatia Exp $
Rem
Rem trace_indexes.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      trace_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    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    jsadras     02/26/04 - jsadras_trace_create 
Rem    jsadras     02/26/04 - TraceIndexes 
Rem    jsadras     02/26/04 - Created
Rem

Rem 
Rem Indices for EMDW_TRACE_CONFIG table
Rem

ALTER TABLE emdw_trace_config
ADD CONSTRAINT emdw_Trace_config_u1 unique
(Context_Type) 
USING INDEX (
              CREATE INDEX emdw_trace_config_idx_01 ON 
                           emdw_trace_config(Context_Type,Context_Type_Id,Trace_Level)
            ) ;


Rem 
Rem Indices for EMDW_TRACE_DATA table
Rem

CREATE INDEX EMDW_TRACE_DATA_IDX_01
ON EMDW_TRACE_DATA
 (
  context_type_id,
  log_timeStamp,
  log_level
  ) 
COMPRESS 1;