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