Each row describes the Nth-most-frequent value or Nth quantile value of
some column. Statistics are not recorded for inherited columns of typed
tables.
Table 103. SYSSTAT.COLDIST Catalog View
| Column Name | Data Type | Nullable | Description | Updatable |
|---|---|---|---|---|
| TABSCHEMA | VARCHAR(128) |
| Qualified name of the table to which this entry applies. |
|
| TABNAME | VARCHAR(128) |
|
| |
| COLNAME | VARCHAR(128) |
| Name of the column to which this entry applies. |
|
| TYPE | CHAR(1) |
| Type of statistic collected:
|
|
| SEQNO | SMALLINT |
| If TYPE = F, then N in this column identifies the Nth most frequent value. If TYPE = Q, then N in this column identifies the Nth quantile value. |
|
| COLVALUE | VARCHAR(254) | Yes | The data value, as a character literal or a null value.
This column can be updated with a valid representation of the value appropriate to the column that the statistic is associated with. If null is the required frequency value, the column should be set to NULL. | Yes |
| VALCOUNT | BIGINT |
| If TYPE = F, then VALCOUNT is the number of occurrences of COLVALUE in
the column. If TYPE = Q, then VALCOUNT is the number of rows whose
value is less than or equal to COLVALUE.
This column can be only updated with the following values:
| Yes |
| DISTCOUNT | BIGINT |
| If TYPE = q, this column records the number of distinct values that are less than or equal to COLVALUE (null if unavailable.) the number of rows whose value is less than or equal to COLVALUE. | Yes |