Rem drv: <create type="indexes"/>
Rem
Rem $Header: log_indexes.sql 29-jun-2005.01:48:27 gsbhatia Exp $
Rem
Rem log_indexes.sql
Rem
Rem Copyright (c) 2002, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      log_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    jsadras     05/02/05 - add index on 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    scgrover    02/01/05 - compress indexes 
Rem    ktlaw       01/11/05 - add repmgr header 
Rem    aholser     10/15/03 - add err index 
Rem    aholser     06/09/03 - rearrange index
Rem    edemembe    10/14/02 - edemembe_add_perf_scripts_020918
Rem    edemembe    10/09/02 - 
Rem    edemembe    09/20/02 - Created
Rem

rem
rem   Indexes for MGMT_SYSTEM_ERROR_LOG
rem

CREATE INDEX MGMT_SYSTEM_ERROR_LOG_01
  ON MGMT_SYSTEM_ERROR_LOG (module_name, log_level, occur_date)
  COMPRESS 2;

rem
rem   Indexes for MGMT_SYSTEM_PERFORMANCE_LOG
rem

CREATE INDEX MGMT_SYSTEM_PERF_LOG_IDX_01
 ON MGMT_SYSTEM_PERFORMANCE_LOG (job_name, time, name)
 COMPRESS 3;

rem
rem   Indexes for MGMT_SYSTEM_PERFORMANCE_LOG
rem

CREATE INDEX MGMT_SYSTEM_PERF_LOG_IDX_02
 ON MGMT_SYSTEM_PERFORMANCE_LOG (time) ;