SYS.COL_STATS

The COL_STATS table stores the statistics for table columns in the data store. Statistics include the number of unique values, number of nulls, number of rows and other information regarding the distribution of column values. No values are present if statistics have not been computed.

Columns

Column name	Type	Description
TBLID	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	TimesTen table identifier.
COLNUM	TT_SMALLINT NOT NULL	Ordinal number of column in table (starting at 1).
INFO	VARBINARY (4000000) NOT INLINE NOT NULL	Contains a binary representative of the column value distribution information. See `ttOptUpdateStats` for an explanation of the distribution information stored in this column. A text representation of this information can be retrieved using `ttOptGetColStats`.