Rem
Rem $Header: storage_ui_indexes.sql 29-jun-2005.01:48:46 gsbhatia Exp $
Rem
Rem storage_ui_indexes.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      storage_ui_indexes.sql 
Rem
Rem    DESCRIPTION
Rem      indexes for tables in storage_ui_tables.sql
Rem
Rem    NOTES
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    gsbhatia    06/26/05 - New repmgr header impl 
Rem    ajdsouza    03/25/05 - moved from latest
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    rmenon      02/04/05 - rmenon_storage_report_ui_fix_12
Rem    rmenon      01/31/05 - Created
Rem

SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100

-- index for the temporary table mgmt_storage_report_ui_targets
-- This index will get used when the number of entries in the
-- temporary table is large. We put target_name first simply
-- because we have queries with where clause having only
-- target_name. In such cases, this indexes could be a
-- candidate for the optimizer.

CREATE INDEX mgmt_storage_ui_target_idx1 ON
  mgmt_storage_report_ui_targets
  (
    target_name, 
    target_type
  );