Contains one row for each index that is defined for a table.
Table 99. SYSSTAT.INDEXES Catalog View
Column Name  Data Type  Nullable  Description  Updatable 

INDSCHEMA  CHAR(8) 
 Qualified name of the index. 

INDNAME  VARCHAR(18) 

 
NLEAF  INTEGER 
 Number of leaf pages; 1 if statistics are not
gathered.
This column can only be updated with the following values:
 Yes 
NLEVELS  SMALLINT 
 Number of index levels; 1 if statistics are not
gathered.
This column can only be updated with the following values:
 Yes 
FIRSTKEYCARD  INTEGER 
 Number of distinct first key values; 1 if statistics are not
gathered.
This column can only be updated with the following values:
 Yes 
FIRST2KEYCARD  INTEGER 
 Number of distinct keys using the first two columns of the index
(1 if no statistics or inapplicable)
This column can only be updated with the following values:
 Yes 
FIRST3KEYCARD  INTEGER 
 Number of distinct keys using the first three columns of the index
(1 if no statistics or inapplicable)
This column can only be updated with the following values:
 Yes 
FIRST4KEYCARD  INTEGER 
 Number of distinct keys using the first four columns of the index
(1 if no statistics or inapplicable)
This column can only be updated with the following values:
 Yes 
FULLKEYCARD  INTEGER 
 Number of distinct full key values; 1 if statistics are not
gathered.
This column can only be updated with the following values:
 Yes 
CLUSTERRATIO  SMALLINT 
 This is used by the optimizer. It indicates the degree of data
clustering with the index; 1 if statistics are not gathered or if
detailed index statistics have been gathered.
This column can only be updated with the following values:
 Yes 
CLUSTERFACTOR  DOUBLE 
 This is used by the optimizer. It is a finer measurement of degree
of clustering, or 1 if detailed index statistics have not been
gathered.
This column can only be updated with the following values:
 Yes 
SEQUENTIAL_PAGES  INTEGER 
 Number of leaf pages located on disk in index key order with few or no
large gaps between them. (1 if no statistics are
available.)
This column can only be updated with the following values:
 Yes 
DENSITY  INTEGER 
 Ratio of SEQUENTIAL_PAGES to number of pages in the range of pages
occupied by the index, expressed as a percent (integer between 0 and 100,
1 if no statistics are available.)
This column can only be updated with the following values:
 Yes 
PAGE_FETCH_PAIRS  VARCHAR(254) 
 A list of pairs of integers, represented in character form. Each
pair represents the number of pages in a hypothetical buffer, and the number
of page fetches required to scan the index using that hypothetical
buffer. (Zerolength string if no data available.)
This column can be updated with the following input values:
 Yes 