ttOptGetColStats
This procedure returns statistics information in text format.
See ttOptSetColIntvlStats for the layout of the statistics.
Required Privilege
This procedure requires the SELECT
privilege on the specified tables.
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
ttOptGetColStats('tblName', 'colName')
Parameters
ttOptGetColStats
has these parameters:
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. |
|
|
Name of the column for which statistics should be returned. If |
Result Set
ttOptGetColStats
returns the result set:
Column | Type | Description |
---|---|---|
|
|
Name of the table. Using a synonym to specify a table name is not supported. |
|
|
Name of the column. |
|
|
Statistics in text form. |
Examples
CALL ttOptGetColStats (); < T1 , X1, (2, 10, 10, 100 (,4, 40, 10 ,1, 10, 5) , (4, 20, 20 ,11, 20, 15) )>
See Also