Contains detailed column statistics for use by the optimizer. Each
row describes the Nth-most-frequent value of some column.
Table 40. SYSCAT.COLDIST Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| 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) |
| 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. |
| 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. |
| DISTCOUNT | INTEGER | Yes | If TYPE=Q, this column records the number of distinct values that are less than or equal to COLVALUE (null if unavailable). |