Administration Guide

SYSCAT.COLDIST

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

Table 70. 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).

[ DB2 List of Books | Search the DB2 Books ]