DELETE STATISTICS

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@]