ttOptStatsExport

This procedure returns the set of statements required to restore the table statistics to the current state. If no table is specified, it returns the set of statements required to restore the table statistics for all user tables that the calling user has permission to access.

Required Privilege

This procedure requires ADMIN privilege.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic.

TimesTen Scaleout applications can call this built-in procedure.

In TimesTen Scaleout, this procedure runs locally on the element from which it is called.

Related Views

This procedure has these related views.

SYS.GV$OPT_STATS

SYS.V$OPT_STATS

Syntax

ttOptStatsExport('tblName')

Parameters

ttOptStatsExport has the parameter:

Parameter Type Description

Parameter	Type	Description
`tblName`	`TT_CHAR (61)`	Name of the table whose statistics are to be returned. If `NULL` is passed, then values for all tables are returned. Using a synonym to specify a table name is not supported.

tblName

TT_CHAR (61)

Name of the table whose statistics are to be returned. If NULL is passed, then values for all tables are returned.

Using a synonym to specify a table name is not supported.

Result Set

ttOptStatsExport returns the result set:

Column	Type	Description
`stmt`	`TT_VARCHAR (8300) NOT NULL`	The set of statements required to restore the table(s) statistics to the current state.

Examples

CALL ttOptStatsExport('MyTable');