Rem drv: <create type="indexes" pos="log/log_indexes.sql+"/>
Rem
Rem $Header: group_indexes.sql 29-jun-2005.01:48:29 gsbhatia Exp $
Rem
Rem group_indexes.sql
Rem
Rem Copyright (c) 2002, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      group_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    dtsao       06/28/05 - Add two indexes 
Rem    pmodi       06/19/05 - Bug:4305824 -Removing index of 
Rem                           mgmt_comp_target_def 
Rem    dtsao       05/24/05 - Bug 4305846 -- Add index 
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    ramalhot    08/24/04 - cutover to new assoc tables 
Rem    streddy     09/22/03 - Added indexes for flat memberships table 
Rem    streddy     08/04/03 - Disable group history tables 
Rem    streddy     03/18/03 - Add index for membership history table
Rem    rpatti      12/18/02 - fix perf
Rem    rpinnama    05/14/02 - rpinnama_reorg_rep_scripts
Rem    rpinnama    05/14/02 - Created
Rem

CREATE INDEX MGMT_GROUP_CHART_IDX_01
  ON MGMT_GROUP_CHART
     (comp_target_guid)
  STORAGE
    (FREELISTS 4)
  INITRANS 4;

CREATE INDEX GROUP_CHART_SELTARGETS_IDX
  ON MGMT_GROUP_CHART_SELTARGETS
     (comp_chart_guid)
  STORAGE
    (FREELISTS 4)
  INITRANS 4;

CREATE INDEX GROUP_CHART_SELTARGETS_IDX2
  ON MGMT_GROUP_CHART_SELTARGETS
     (target_guid)
  STORAGE
    (FREELISTS 4)
  INITRANS 4;

CREATE INDEX GROUP_CUSTOM_COLUMNS_IDX
  ON MGMT_GROUP_CUSTOM_COLUMNS 
     (COMPOSITE_TARGET_GUID)
  STORAGE
    (FREELISTS 4)
  INITRANS 4;

CREATE INDEX GROUP_SUMMARY_CHART_DEF_IDX
  ON MGMT_GROUP_SUMMARY_CHART_DEF
     (COMP_CHART_GUID)
  STORAGE
    (FREELISTS 4)
  INITRANS 4;

CREATE INDEX GROUP_SUMMARY_CHART_DEF_IDX2
  ON MGMT_GROUP_SUMMARY_CHART_DEF
     (COMP_TARGET_GUID)
  STORAGE
    (FREELISTS 4)
  INITRANS 4;