Index Data

If an index is used, that is, an access path other than TABLE SPACE SCAN, information about this index is shown. The data is derived from the SYSIBM.SYSINDEXES table.

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

Explain Report - Index Data Block

Here is an example of the index data block section.

INDEX: SYSIBM.DSNKKX01 --------------------------------------------------------
STATSTIME: 2016-02-16-14.45.54.186869
CREATED  : 0001-01-01-00.00.00.000000     ALTERED: 2003-09-21-23.30.17.962937
FULL KEY CARD:       885,PAGES :        16,LEVELS:       2,CLUSTRING: Y
1"ST KEY CARD:         1,SPACE :  245.760K,UNIQUE:     YES,CLUSTERED: N
INDEX TYPE   :         2,PGSIZE:      4096,BFPOOL:     BP0,DB.NAME  : DSNDB06
CLUSTERRATIO :  84.6328%,ERRULE:        NO,CLRULE:      NO,IXSPACE  : DSNKKX01
MAX.PIECESIZE:         0,COPY  :        NO,COPYLRSN: X'000000000000'