SYS.TBL_STATS

The TBL_STATS table stores the statistics for tables in the database, 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.