ttOptStatsExport
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.
Syntax
ttOptStatsExport('tblName')
Parameters
ttOptStatsExport
has the parameter:
Parameter | Type | Description |
---|---|---|
|
|
Name of the table whose statistics are to be returned. If Using a synonym to specify a table name is not supported. |
Result Set
ttOptStatsExport
returns the result set:
Column | Type | Description |
---|---|---|
|
|
The set of statements required to restore the table(s) statistics to the current state. |
Examples
CALL ttOptStatsExport('MyTable');
See Also
- Create Script to Regenerate Current Table Statistics in the Oracle TimesTen In-Memory Database Operations Guide.