DROP STATISTICS
DROP STATISTICS
— remove table statistics
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.