SYS.TBL_STATS

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

See "SYS.COL_STATS".

Columns

Column name	Type	Description
TBLID	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	TimesTen identifier of table.
NUMTUPS	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	Number of rows in the table.
LASTSTATSUPDATE	TT_CHAR (25)	Time of most recent update of this table, in the following format: Day Mon DD HH:MM:SS YYYY (e.g., Sun Jan 01 18:24:12 1995). The string is NULL-terminated. This column is NULL if no statistics update has been performed on the table.

Column name

Type

Description

TBLID

TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

TimesTen identifier of table.

NUMTUPS

TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

Number of rows in the table.

LASTSTATSUPDATE

TT_CHAR (25)

Time of most recent update of this table, in the following format:

Day Mon DD HH:MM:SS YYYY

(e.g., Sun Jan 01 18:24:12 1995).

The string is NULL-terminated.

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