| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| NAME |
VARCHAR(18) NOT NULL |
Name of the index. |
G |
| CREATOR |
CHAR(8) NOT NULL |
Authorization ID of the owner of the index. |
G |
| TBNAME |
VARCHAR(18) NOT NULL |
Name of the table on which the index is defined. |
G |
| TBCREATOR |
VARCHAR(18) NOT NULL |
Authorization ID of the owner of the table. |
G |
| CLUSTERING |
CHAR(1) NOT NULL |
Whether CLUSTER was specified when the index was created:
N No
Y Yes |
G |
| NLEAF |
INTEGER NOT NULL
WITH DEFAULT -1 |
Number of active leaf pages in the index. 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. If the index is partitioned, it is the maximum of
the number of levels in the index tree for all the partitions. The value is -1 if
statistics have not been gathered. |
S |
| STATSTIME |
TIMESTAMP NOT NULL |
If RUNSTATS updated the statistics, the date and time when the last invocation of
RUNSTATS updated the statistics.
The default value is '0001-01-01-00.00.00.000000'. |
G |
| FIRSTKEYCARDF |
FLOAT(8) NOT NULL
WITH DEFAULT -1 |
Number of distinct values of the first key column. This number is an estimate if
updated while collecting statistics on a single partition. The value is -1 if statistics
have not been gathered. |
S |
| FULLKEYCARDF |
FLOAT(8) NOT NULL
WITH DEFAULT -1 |
Number of distinct values of the key. The value is -1 if statistics have not been
gathered. |
S |
| CLUSTERRATIOF |
FLOAT(8) NOT NULL |
Percentage of rows that are in clustering order. For a partitioning index, it is the
weighted average of all index partitions in terms of the number of rows in the
partition. The value is 0 if statistics have not been gathered. The value is -2 if the
index is for an auxiliary table. |
G |
| SPACEF |
FLOAT(8) NOT NULL
WITH DEFAULT -1 |
Number of kilobytes of DASD storage allocated to the index space partition. The
value is -1 if statistics have not been gathered. |
G |
| IBMREQD |
CHAR(1) NOT NULL
WITH DEFAULT 'N' |
A value of Y indicates that the row came from the basic machine-readable material
(MRM) tape. For all other values, see Release dependency indicators in topic D.0. |
G |
