Skip to main content

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.