SYSINDEXSTATS_HIST catalog table

The SYSINDEXSTATS_HIST catalog table contains rows from the SYSINDEXSTATS table. The schema is SYSIBM.

Rows are added or changed in this table when RUNSTATS collects history statistics. Rows in this table can also be inserted, updated, and deleted.

Table 1. SYSIBM.SYSINDEXSTATS_HIST table column descriptions
Column name Data type Description Use
NLEAF
INTEGER
NOT NULL WITH
DEFAULT -1
 Number of active leaf pages in the index partition. The value is -1 if statistics have not been gathered. S
NLEVELS
SMALLINT
NOT NULL WITH
DEFAULT -1
 Number of levels in the index tree. The value is -1 if statistics have not been gathered. S
STATSTIME
TIMESTAMP
NOT NULL

Start of changeIf RUNSTATS or another utility with inline statistics updated the statistics, the date and time when the last utility invocation updated the statistics. The default value is '0001-01-01-00.00.00.000000'. The default value indicates that statistics were not collected. This column can be updated.End of change

 G
PARTITION
SMALLINT
NOT NULL
 Partition number of the index. G
OWNER
VARCHAR(128)  
NOT NULL

The schema of the index.

 G
NAME
VARCHAR(128)
NOT NULL
 Name of the index. G
FIRSTKEYCARDF
FLOAT(8)
NOT NULL WITH
DEFAULT -1
 For the index partition, number of distinct values of the first key column. The value is -1 if statistics have not been gathered. S
FULLKEYCARDF
FLOAT(8)
NOT NULL WITH
DEFAULT -1
 For the index partition, number of distinct values of the key. The value is -1 if statistics have not been gathered. S
KEYCOUNTF
FLOAT(8)
NOT NULL WITH
DEFAULT -1
 Total number of RIDs in the index partition. The value is -1 if statistics have not been gathered.Total number of rows in the partition. The value is -1 if statistics have not been gathered.

For a sparse index, the statistic is based on the actual contents of the index.

 S
CLUSTERRATIOF
FLOAT(8)
NOT NULL
 For the index partition, the value, when multiplied by 100, is the percentage of rows that are in clustering order. For example, a value of '0.9125' indicates 91.25%. The value is 0 if statistics have not been gathered.

For a sparse index, the statistic is based on the actual contents of the index.

 G
IBMREQD
CHAR(1)
NOT NULL WITH
DEFAULT 'N'
 A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies.

 G
DATAREPEATFACTORF
FLOAT
NOT NULL WITH
DEFAULT -1
 The anticipated number of data pages that will be touched following an index key order. This number is -1 if statistics have not been collected. This is an updatable column.

For a sparse index, the statistic is based on the actual contents of the index.

 G