SQL Reference

SYSCAT.COLDIST

Contains detailed column statistics for use by the optimizer. Each row describes the Nth-most-frequent value of some column.

Table 49. SYSCAT.COLDIST Catalog View
Column Name Data Type Nullable Description
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)

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(254) Yes The data value, as a character literal or a null value.
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.

DISTCOUNT BIGINT Yes If TYPE = Q, this column records the number of distinct values that are less than or equal to COLVALUE (null if unavailable).


[ Top of Page | Previous Page | Next Page ]