| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| STATSTIME |
TIMESTAMP NOT NULL |
If RUNSTATS updated the statistics, the date and time when the last invocation of
RUNSTATS updated the statistics. |
G |
| TBOWNER |
CHAR(8) NOT NULL |
Authorization ID of the owner of the table that contains the column. |
G |
| TBNAME |
VARCHAR(18) NOT NULL |
Name of the table that contains the column. |
G |
| NAME |
VARCHAR(18) NOT NULL |
Name of the column. If NUMCOLUMNS is greater than 1, this name identifies the
first column name of the set of columns associated with the statistics. |
G |
| COLVALUE |
VARCHAR(255) NOT NULL
FOR BIT DATA |
Contains the data of a frequently occurring value. Statistics are not collected for an
index on a ROWID column. If the value has a non-character data type, the data
might not be printable. |
S |
| TYPE |
CHAR(1) NOT NULL
WITH DEFAULT 'F' |
The type of statistics gathered:
C Cardinality
F Frequent value |
G |
| CARDF |
FLOAT(8) NOT
NULL WITH DEFAULT -1 |
Number of distinct values for the column group. This number is valid only for
TYPE C statistics. The value is -1 if statistics have not been gathered. |
S |
| COLGROUPCOLNO |
VARCHAR(254) NOT NULL |
Identifies the set of columns associated with the statistics. If the statistics are only
associated with a single column, the field contains a zero length. Otherwise, the
field is an array of SMALLINT column numbers with a dimension equal to the value
in NUMCOLUMNS. |
S |
| NUMCOLUMNS |
SMALLINT NOT NULL
WITH DEFAULT 1 |
Identifies the number of columns associated with the statistics. |
G |
| FREQUENCYF |
FLOAT(8) NOT NULL DEFAULT -1 |
Gives the percentage of rows in the table with the value specified in COLVALUE
when the number is multiplied by 100. For example, a value of 1 indicates 100%. A
value of .153 indicates 15.3%. Statistics are not collected for an index on a
ROWID column. The value is -1 if statistics have not been gathered. |
G |
| IBMREQD |
CHAR(1) NOT NULL 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 |
