DROP STATISTICS FOR COLUMNS

This command terminates an ANALYZE TABLE execution.

More about statistics under Cost-Based Optimizer

Syntax

ALTER TABLE '<table_name>' DROP STATISTICS FOR COLUMNS '<column_name>' [, ...]

Parameters

Parameter	Description	Parameter Type
table_name	Identifier	Identifies the table for which to apply statistics
column_name	Identifier	Identifies the column for which to apply statistics

Examples

ALTER TABLE "nba" DROP STATISTICS FOR COLUMNS "number";

Permissions