SYSSTAT.COLGROUPS catalog view

Each row represents a column group and statistics that apply to the entire column group.

Table 1. SYSSTAT.COLGROUPS Catalog View
Column Name Data Type Nullable Updat-ableUpdatable Description
COLGROUPSCHEMA VARCHAR (128)     Schema name of the column group.
COLGROUPNAME VARCHAR (128)     Unqualified name of the column group.
COLGROUPID INTEGER     Identifier for the column group.
COLGROUPCARD BIGINT   Y Cardinality of the column group.
NUMFREQ_VALUES SMALLINT     Number of frequent values collected for the column group.
NUMQUANTILES SMALLINT     Number of quantiles collected for the column group.