ttOptSetTblStats

Description

Modifies the statistics for the specified table. This procedure allows an application to set statistics explicitly rather than have TimesTen automatically compute them.

Required privilege

This procedure requires no privilege (if owner) or ALTER ANY TABLE privilege (if not owner).

Syntax

ttOptSetTblStats('tblName', numRows, invalidate)

Parameters

ttOptSetTblStats has these parameters:

Parameter	Type	Description
`tblName`	TT_CHAR(61) NOT NULL	Name of an application table. Can include table owner.
`numRows`	TT_INTEGER NOT NULL	Number of rows in the table.
`invalidate`	TT_INTEGER	0 (no) or 1 (yes). If `invalidate` is 1, all commands that reference the affected tables are automatically prepared again when re-executed, including commands prepared by other users. If `invalidate` is 0, the statistics are not considered to have been modified and existing commands are not reprepared.

Result set

ttOptSetTblStats returns no results.

Example

CALL ttOptSetTblStats ( 'ACCTS', 10000, 0 );

Note

This feature is useful for preparing commands before the data has been inserted or for seeing how table size can affect the choice of an execution plan. Because the command can be used before any data are in the table, the values specified do not need to bear any relation to the actual values. This procedure modifies the relevant row(s) in the TBL_STATS system table. See "SYS.TBL_STATS" in Oracle TimesTen In-Memory Database SQL Reference.