| Nome da coluna |
Tipo de dado |
Descrição |
Uso |
| |
SMALLINT NOT NULL |
Not used |
N |
| STATSTIME |
TIMESTAMP NOT NULL WITH DEFAULT |
If RUNSTATS updated the statistics, the date and time when the last invocation of
RUNSTATS updated the statistics. |
G |
| IBMREQD |
CHAR(1) NOT NULL |
Whether the row came from the basic machine-readable material (MRM) tape.
N No
Y Yes |
G |
| TBOWNER |
CHAR(8) NOT NULL |
Authorization ID of the owner of the table containing 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(254) NOT NULL FOR BIT DATA |
Contains the data of a frequently occurring value. 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 NOT NULL WITH DEFAULT -1 |
The number of distinct values for the column group. This number is valid only
for TYPE C statistics. |
S |
| COLGROUPCOLNO |
VARCHAR(254) NOT NULL WITH DEFAULT |
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. This is an updatable column. |
S |
| NUMCOLUMNS |
SMALLINT NOT NULL WITH
DEFAULT 1 |
Identifies the number of columns associated with the statistics. |
G |
| FREQUENCYF |
FLOAT NOT NULL WITH
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%. |
|
