DELETE STATISTICS-CSDN博客

本文介绍如何使用DELETE STATISTICS语句来删除Oracle数据库中特定表或集群的系统统计信息及用户定义统计信息。当不再需要Oracle使用这些统计信息时，可以采用此方法进行清理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Specify DELETE STATISTICS to delete any statistics about the analyzed object that are
currently stored in the data dictionary. Use this statement when you no longer want
Oracle Database to use the statistics.

When you use this clause on a table, the database also automatically removes statistics
for all the indexes defined on the table. When you use this clause on a cluster, the
database also automatically removes statistics for all the cluster tables and all their
indexes, including the cluster index.

Specify SYSTEM if you want Oracle Database to delete only system (not user-defined)
statistics. If you omit SYSTEM, and if user-defined column or index statistics were
collected for an object, then the database also removes the user-defined statistics by
invoking the statistics deletion function specified in the statistics type that was used to
collect the statistics.

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-1001632/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-1001632/