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 the SYSINDEXSTATS_HIST catalog table when RUNSTATS collects history statistics. Rows in this table can also be inserted, updated, and deleted.
| 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 |
If 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. |
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 |