SYSCS_UTIL.DISABLE_COLUMN_STATISTICS

The SYSCS_UTIL.DISABLE_COLUMN_STATISTICS  system procedure disables collection of statistics on a specific table column in your database.

Syntax

SYSCS_UTIL.DISABLE_COLUMN_STATISTICS(
                       VARCHAR(128) schema,
                       VARCHAR(128) table,
                       VARCHAR(128) columnName)

schemaName

Specifies the schema of the table. Passing a null or non-existent schema name generates an error.

tableName

Specifies the table name of the table. The string must exactly match the case of the table name, and the argument of "Fred" will be passed to SQL as the delimited identifier 'Fred'. Passing a null or non-existent table name generates an error.

columnName

Specifies the name of the column for which you want statistics disabled. Passing a null or non-existent column name generates an error.

Results

This procedure does not return a result.

Usage Notes

Statistics are automatically collected on all columns by default. Attempting to disable statistics collection on a keyed column generates an error.

SQL Examples

splice> CALL SYSCS_UTIL.DISABLE_COLUMN_STATISTICS('SPLICE', 'Salaries', 'Salary');
Statement executed.

See Also