SQL Reference

SYSSTAT.COLDIST

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:

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.

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:

  • >= 0 (zero)
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


[ Top of Page | Previous Page | Next Page ]