Oracle® TimesTen In-Memory Database SQL Reference Release 11.2.1 Part Number E13070-03 |
|
|
View PDF |
The TCOL_STATS table stores the statistics for table columns in temporary table instances 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 |
---|---|---|
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 NULL NOT INLINE | 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 . |