Key Distribution Data

This section introduces the Key Distribution Data.

If LEVEL(KEYDIST) has been specified and RUNSTATS has produced key distribution information for the first column of the index, a section in the report shows the distribution of up to ten most frequently used key values. The data is derived from the SYSIBM.SYSTABLES.CREATOR.

For details on how to specify EXPLAIN commands refer to the Report Command Reference.

Explain Report - Key Distribution Data Block

This example shows the key distribution data section.

KEY DISTRIBUTION FOR : SYSIBM.SYSTABLES.CREATOR       -------------------------
SYSIBM    (27%),DSNB230   (11%),U473298   ( 9%),Q         ( 7%),XXASP09   ( 5%)
U01       ( 5%),USR2      ( 5%),XXASP32   ( 3%),XXASP16   ( 3%),USER001   ( 2%)