DROP STATS

Description

Deletes CBO statistics, which include basic statistics and histograms. For more information, see Gather statistics for CBO.

You can delete statistical information you do not need. When you delete statistics, both the data and metadata of the statistics are deleted, as well as the statistics in expired cache. Note that if an automatic collection task is ongoing, previously deleted statistics may be collected again. You can use SHOW ANALYZE STATUS to view the history of collection tasks.

This statement is supported from v2.4.

Syntax

Delete basic statistics

DROP STATS tbl_name

Delete histograms

ANALYZE TABLE tbl_name DROP HISTOGRAM ON col_name [, col_name];

References

For more information about collecting statistics for CBO, see Gather statistics for CBO.