| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| 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 partition index tree. 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 |
| OWNER |
CHAR(8) NOT NULL |
Authorization ID of the owner of the index. |
G |
| NAME |
VARCHAR(18) 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 rows in the partition. The value is -1 if statistics have not been
gathered. |
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 indicates 91.25%. The
value is 0 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 |
