DROP STATISTICS

DROP STATISTICS — remove table statistics

Syntax

DROP STATISTICS [schema.]statistics_name [IF EXISTS]

Description

DROP STATISTICS removes existing table statistics that were computed for specific table columns. These specific table statistics will not be computed the next time that ANALYZE is performed on table_name. Per column statistics and histograms computed for indexed columns will not be affected.

To execute this command you must be the owner of the statistics.

If the statistics do not exist and DROP STATISTICS is used without the IF EXISTS clause, an error is reported.

Refer to CREATE STATISTICS for information on how to create statistics.

Parameters

IF EXISTS

If the statistics do not exist and you specify IF EXISTS, NuoDB does not generate an error. Otherwise, if the statistics do not exist, an error is generated.

schema

Optional. The name of the schema that owns the statistics to be dropped. If schema is not provided, the current schema is implied.

statistics_name

Name of the statistics to remove.

Example

CREATE STATISTICS stats_teams ON hockey.teams(conferenceid, year);
DROP STATISTICS stats_teams;
DROP STATISTICS stats_teams IF EXISTS;