Use
You can use this SAPDBA command with the Oracle database to delete statistics used by the cost-based optimizer (CBO).
We strongly recommend you to use the
Syntax
To delete statistics, for one or more tablespaces or for a particular table enter the following command:
sapdba -delete <tablespace(s)>|<table>
To 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 the DBSTATC control table):sapdba -delete HARMFUL
See also:
sapdba -checkopt Update Statistics for the Cost-Based Optimizer with SAPDBA Updating Statistics using Optimizer Control with SAPDBA Update Statistics for the Cost-Based Optimizer in CCMS (Oracle)