COL_STATSsystem table. Modifying interval statistics for a column that is not currently indexed has no effect.
Because this procedure can be used before any data is in the table, the values specified do not need to bear any relation to the actual values, although some basic validity checking is performed.
This procedure requires no privilege (if owner) or
ALTER ANY TABLE privilege (if not owner).
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 on all elements in the grid.
This procedure has no related views.
ttOptSetColIntvlStats('tblName', 'colName', invalidate, (stats))
ttOptSetColIntvlStats has these parameters:
Name of an application table. Can include table owner. Using a synonym to specify a table name is not supported.
Name of a column in that table.
Sets stats for the column, using the format:
The modal value (
Because this parameter is a compound structure it cannot be parameterized using ODBC functions or described using the
ttOptSetColIntvlStats returns no results.
To set the following statistics for column
10 rows with null value
10 unique value
Interval 1(4 unique values besides the most frequently occurring value, 40 rows with values other than most frequently occurring value, 10 rows with most frequently occurring value,
min = 1,
max = 10,
mod = 5)
Interval 2(4 unique values besides the most frequently occurring value, 20 rows with values other than most frequently occurring, 20 rows with most frequently occurring value,
min = 11,
max = 20,
mod = 15)
Use the statement:
CALL ttOptSetColIntvlStats('t1', 'x1', 1, (2, 10, 10, 100, (4, 40, 10, 1, 10, 5), (4, 20, 20, 11, 20, 15)));
You must specify the minimum and maximum values in the interval as
NULL values are not permitted as minimum or maximum values. The value is stored in the platform-specific endian format.