Duplicate indexes This report lists indexes that could be eliminated by recreating them in a different order. By recreating the indexes with the most key fields followed by the ones with progressively fewer and fewer keys, DB2 UDB for the iSeries will reuse existing access paths as much as possible. This will reduce disk space, improve update times, and minimize backup time and space.
Report Summary
Date of report: 2004-10-26 Time of report: 15:26:00 Report data retrieved from system: flash ODBC DSN used for the report: VDT_FLASH ODBC DSN User id: david Library used in this report: *ALL
FILE1			FILE2
DW_STORE/DWF_MNTSTL/DWF_MNTSTL			DW_STORE/XPK_FCTSTL/XPK_FCTSTL
DW_STORE/DWA_CRD/DWA_CRD			DW_STORE/XPKA_CRD/XPKA_CRD
DW_STORE/DWD_MRAC/DWD_MRAC			DW_STORE/XPKD_MRAC/XPKD_MRAC
DW_STORE/DWD_TX_CD/DWD_TX_CD			DW_STORE/XPKD_TX_CD/XPKD_TX_CD
DW_STORE/DWD_TXCCC/DWD_TXCCC			DW_STORE/XPKD_TXCCC/XPKDW00002
DW_STORE/XPKD_TXMHD/XPKD_TXMHD			DW_STORE/DWD_TXMTHD/DWD_TXMTHD
DW_STORE/DWD_STLCD/DWD_STLCD			DW_STORE/XPKDSTLCD/XPKDSTLCD
DW_STORE/DWD_AC/DWD_AC			DW_STORE/XPKDWD_AC/XPKDWD_AC
DW_STORE/DWD_ACQ/DWD_ACQ			DW_STORE/XPKDWD_ACQ/XPKDWD_ACQ
DW_STORE/DWD_CRD/DWD_CRD			DW_STORE/XPKDWD_CRD/XPKDWD_CRD
DW_STORE/DWD_DAY/DWD_DAY			DW_STORE/XPKDWD_DAY/XPKDWD_DAY
DW_STORE/DWD_FRD/DWD_FRD			DW_STORE/XPKDWD_FRD/XPKDWD_FRD
DW_STORE/DWD_MR/DWD_MR			DW_STORE/XPKDWD_MR/XPKDWD_MR
DW_STORE/DWD_PRD/DWD_PRD			DW_STORE/XPKDWD_PRD/XPKDWD_PRD
DW_STORE/DWF_MSC/DWF_MSC			DW_STORE/XPKDWF_MSC/XPKDWF_MSC
DW_STORE/XPKDW00004/XPKDW00004			DW_STORE/DWD_FRD_TX/DWD_FRD_TX
DW_STORE/DWF_TX/DWF_TX			DW_STORE/XPKF_TX/XPKF_TX
DW_STORE/XVI0DWF_TX/XVI0DWF_TX			DW_STORE/XIF3F_TX/XIF3F_TX
DW_STORE/XVI1D_AC/XVI1D_AC			DW_STORE/XIF43D_AC/XIF43D_AC
DW_STORE/XVI1D_CRD/XVI1D_CRD			DW_STORE/XIF2D_CRD/XIF2D_CRD
DW_STORE/XVI1D_MR/XVI1D_MR			DW_STORE/XIE3D_MR/XIE3D_MR
DW_STORE/XVI1DWF_TX/XVI1DWF_TX			DW_STORE/XIF2F_TX/XIF2F_TX
DW_STORE/XVI1F_MSC/XVI1F_MSC			DW_STORE/XIF1600001/XIF1600001
DW_STORE/XVI1FCTSTL/XVI1FCTSTL			DW_STORE/XIF28FCSTL/XIF28FCSTL
DW_STORE/XVI2D_CRD/XVI2D_CRD			DW_STORE/XIE4D_CRD/XIE4D_CRD
DW_STORE/XVI2D_MR/XVI2D_MR			DW_STORE/XIE4D_MR/XIE4D_MR
DW_STORE/XVI2DWF_TX/XVI2DWF_TX			DW_STORE/XIF5F_TX/XIF5F_TX
DW_STORE/XVI2FCTSTL/XVI2FCTSTL			DW_STORE/XIF44FCSTL/XIF44FCSTL
DW_STORE/XVI3D_CRD/XVI3D_CRD			DW_STORE/XIE10D_CRD/XIE10D_CRD
DW_STORE/XVI3D_MR/XVI3D_MR			DW_STORE/XIE6D_MR/XIE6D_MR
DW_STORE/XVI3DWF_TX/XVI3DWF_TX			DW_STORE/XIF7F_TX/XIF7F_TX
DW_STORE/XVI4D_CRD/XVI4D_CRD			DW_STORE/XIE2D_CRD/XIE2D_CRD
DW_STORE/XVI4DWF_TX/XVI4DWF_TX			DW_STORE/XIF8F_TX/XIF8F_TX
DW_STORE/XVI5DWF_TX/XVI5DWF_TX			DW_STORE/XIE1F_TX/XIE1F_TX
DW_STORE/XVI6DWF_TX/XVI6DWF_TX			DW_STORE/XIE4F_TX/XIE4F_TX
DW_STORE/XVI7DWF_TX/XVI7DWFXXX			DW_STORE/XIE5F_TX/XIE5F_TX
DW_STORE/XVI9DWF_TX/XVI9DWF_TX			DW_STORE/XIF6F_TX/XIF6F_TX