|
SYSIBM.SYSINDEXSTATS_HIST www.cadcobol.com - linguagem de programação COBOL |
|
|
|
|
| Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. |
Contains rows from SYSINDEXSTATS. Rows are added or changed in this table when RUNSTATS collects history statistics. Rows in this table can also be inserted, updated, and deleted.
| 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 |