SYS.TTBL_STATS

The TTBL_STATS table stores the statistics for temporary tables associated with active sessions, namely the number of rows in the table. No values are present if the statistics have not been computed.

Column-specific statistics are stored in the SYS.COL_STATS table.

Columns

Column name Type Description

Column name	Type	Description
`TBLID`	`TT_BIGINT NOT NULL`	TimesTen identifier of table
`NUMTUPS`	`TT_BIGINT NOT NULL`	Number of rows in the table
`LASTSTATSUPDATE`	`TT_CHAR(25)`	Time of most recent update of this table Time is in the following format: Day Mon DD HH:MI:SS YYYY For example: Sun Jan 03 18:24:12 2010 The string is null-terminated. This column is `NULL` if no statistics update has been performed on the table.

TBLID

TT_BIGINT NOT NULL

TimesTen identifier of table

NUMTUPS

TT_BIGINT NOT NULL

Number of rows in the table

LASTSTATSUPDATE

TT_CHAR(25)

Time of most recent update of this table

Time is in the following format:

Day Mon DD HH:MI:SS YYYY

For example:

Sun Jan 03 18:24:12 2010

The string is null-terminated.

This column is NULL if no statistics update has been performed on the table.