Rem drv: <migrate type="schema_upgrade" version="10.2.0.1" pos="system_dashboard/system_dashboard_schema_upgrade.sql+"/>
Rem 
Rem $Header: group_schema_upgrade.sql 25-jul-2005.14:22:33 chyu Exp $
Rem
Rem group_schema_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      group_schema_upgrade.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    chyu        07/25/05 - modifying the upgrade header 
Rem    chyu        07/18/05 - modify the version number in the header 
Rem    dtsao       07/15/05 - dtsao_bug-4487268
Rem    dtsao       07/13/05 - 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;