Each row describes the Nth-most-frequent value or Nth quantile value of
some column.
Table 96. SYSSTAT.COLDIST Catalog View
| Column Name | Data Type | Nullable | Description | Updatable |
|---|---|---|---|---|
| TABSCHEMA | CHAR(8) |
| Qualified name of the table to which this entry applies. |
|
| TABNAME | VARCHAR(18) |
|
| |
| COLNAME | VARCHAR(18) |
| Name of the column to which this entry applies. |
|
| TYPE | CHAR(1) |
| Type of statistic collected:
F=Frequency (most frequent value) Q=Quantile value |
|
| 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(33) | 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 | INTEGER |
| 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 | INTEGER |
| If TYPE=q, this column records the number of distinct values that are less than or equal to COLVALUE (null iv unavailable.) the number of rows whose value is less than or equal to COLVALUE. | Yes |