Skip Headers
Oracle® TimesTen In-Memory Database SQL Reference
Release 11.2.1

Part Number E13070-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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.