SYS.TCOL_STATS

The TCOL_STATS table stores the statistics for table columns in temporary tables associated with active sessions. 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

Column name	Type	Description
`TBLID`	`TT_BIGINT NOT NULL`	TimesTen table identifier
`COLNUM`	`TT_SMALLINT NOT NULL`	Ordinal number of column in table (starting at 1)
`INFO`	`VARBINARY(4194304) NOT INLINE NOT NULL`	Binary representative of the column value distribution information See ttOptUpdateStats in Oracle TimesTen In-Memory Database Reference for an explanation of the distribution information stored in this column. A text representation of this information can be retrieved using the `ttOptGetColStats` built-in procedure.

TBLID

TT_BIGINT NOT NULL

TimesTen table identifier

COLNUM

TT_SMALLINT NOT NULL

Ordinal number of column in table (starting at 1)

INFO

VARBINARY(4194304) NOT INLINE NOT NULL

Binary representative of the column value distribution information

See ttOptUpdateStats in Oracle TimesTen In-Memory Database Reference for an explanation of the distribution information stored in this column. A text representation of this information can be retrieved using the ttOptGetColStats built-in procedure.