You can use this option to delete statistics for one or more tablespaces or for a particular table.
Input syntax:
-delete <tablespace(s)>|<table>You can also delete statistics that are not required by the cost-based optimizer, or that are harmful (pooled and cluster tables, tables with
Active = n or R in DBSTATC ).Input syntax:
-delete HARMFUL -checkopt Support for the Cost-Based Optimizer SAPDBA: DB Optimizer Control
CCMS Support for the Cost-Based Optimizer