Most used indexes based on physical reads This report identifies the logical files that are most heavily used by applications. These are the logical files (access paths) that should  1) be converted to *1TB indexes via CHGLF if they are still *4GB  2) used to reorganize the physical file if the logical file is read sequentially by application programs or  3) be cached in memory via the SETOBJACC command as programs start to use it.
Report Summary Date of report: 2004-08-06 Time of report: 09:19:51 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	PHYSICAL READS		% OF TOTAL
TPCH	L_EXTENDED	L_EXTENDED	61		10.8156
ISTEMP	IDX_J00001	IDX_J00001	41		7.2695
ISTEST	IDX_DATE	IDX_DATE	40		7.0922
ISTEMP	IDX_MBRJKY	IDX_MBRJKY	39		6.9149
ISTEMP	IDX_MBRTIM	IDX_MBRTIM	37		6.5603
ISTEMP	IDX_U00001	IDX_U00001	35		6.2057
ISTEMP	IDX_M00004	IDX_M00004	33		5.8511
ISTEST	IDX_FULL	IDX_FULL	32		5.6738
ISTEST	IDX_TIME	IDX_TIME	32		5.6738
TPCH	L_QUANTLOW	L_QUANTLOW	32		5.6738
ISTEMP	IDX_M00006	IDX_M00006	32		5.6738
ISTEMP	IDX_MBRDAT	IDX_MBRDAT	30		5.3191
ISTEST	IDX_RCDDSC	IDX_RCDDSC	23		4.0780
ISTEMP	IDX_M00002	IDX_M00002	21		3.7234
ISTEMP	IDX_W00001	IDX_W00001	19		3.3688
ISTEST	MBLIB00001	MBLIB00001	18		3.1915
ISTEMP	IDX_MBRJGR	IDX_MBRJGR	11		1.9504
ISTEMP	IDX_D00001	IDX_D00001	10		1.7730
TPCH	L_QUANTITY	L_QUANTITY	9		1.5957
ISTEMP	IDX_M00003	IDX_M00003	9		1.5957
			564