Most used indexes based on logical reads
This report shows the most heavily used logical files based on the number of times they have been read by an application. This report can be used to identify the logical access paths that are used the most by interactive and batch programs and those that are candidates for further optimization (SETOBJACC, conversion to *1TB size, conversion to SQL indexes, etc.)
     
     
Report Summary
Date of report: 2004-08-06
Time of report: 09:20:32
Report data retrieved from system: flash
ODBC DSN used for the report: VDT_FLASH
ODBC DSN User id: ISEREMET
Library used in this report: *ALL
LIBRARY FILE MEMBER LOGICAL READS
ISTEMP    IDX_J00001 IDX_J00001 85
ISTEMP    IDX_M00002 IDX_M00002 83
ISTEMP    IDX_M00004 IDX_M00004 73
ISTEMP    IDX_MBRTIM IDX_MBRTIM 71
TPCH      L_QUANTLOW L_QUANTLOW 67
ISTEMP    IDX_M00006 IDX_M00006 66
ISTEMP    IDX_U00001 IDX_U00001 60
ISTEST    IDX_RCDDSC IDX_RCDDSC 59
ISTEST    IDX_TIME  IDX_TIME  55
TPCH      L_EXTENDED L_EXTENDED 52
ISTEST    IDX_DATE  IDX_DATE  46
ISTEMP    IDX_MBRJKY IDX_MBRJKY 41
ISTEST    IDX_FULL  IDX_FULL  37
ISTEMP    IDX_MBRDAT IDX_MBRDAT 35
TPCH      L_QUANTITY L_QUANTITY 29
ISTEMP    IDX_M00005 IDX_M00005 28
ISTEMP    IDX_LIB   IDX_LIB   26
ISTEMP    IDX_MBRJNK IDX_MBRJNK 25
ISTEST    IDX_MBFILE IDX_MBFILE 24
ISTEMP    IDX_M00001 IDX_M00001 23