Contains one row for each column for which statistics can be updated.
Note: | Summary tables are not included in this view for Version 5.2. If updating statistics for a summary table, use the OBJSTAT.COLUMNS view (see Appendix K. "Catalog Views For Use With Structured Types" for how to define this view). |
Table 97. SYSSTAT.COLUMNS Catalog View
Column Name | Data Type | Nullable | Description | Updatable |
---|---|---|---|---|
TABSCHEMA | CHAR(8) |
| Qualified name of the table that contains the column. |
|
TABNAME | VARCHAR(18) |
|
| |
COLNAME | VARCHAR(18) |
| Column name. |
|
COLCARD | INTEGER |
| Number of distinct values in the column; -1 if statistics are
not gathered.
For any column, COLCARD cannot have a value higher than the cardinality of the table containing that column. This column can only be updated with the following values:
| Yes |
HIGH2KEY | VARCHAR(33) |
| Second highest value of the column. This field is empty if
statistics are not gathered.
This column can be updated with a valid representation of the value appropriate to the column that the statistic is associated with. LOWKEY2 should not be greater than HIGH2KEY. | Yes |
LOW2KEY | VARCHAR(33) |
| Second lowest value of the column. Empty if statistics not
gathered.
This column can be updated with a valid representation of the value appropriate to the column that the statistic is associated with. | Yes |
AVGCOLLEN | INTEGER |
| Average column length. -1 if a long field or LOB, or statistics
have not been collected.
This column can only be updated with the following values:
| Yes |