Entering content frameSyntax documentation sapdba -delete Locate the document in its SAP Library structure

Use

You can use this SAPDBA command with the Oracle database to delete statistics used by the cost-based optimizer (CBO).

Recommendation

We strongly recommend you to use the BRCONNECT equivalent function -f stats instead of this SAPDBA command. The reason is that we will in future no longer develop the SAPDBA functions, whereas BRCONNECT functions will always be fully up-to-date.

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

Structure linkUpdate Statistics for the Cost-Based Optimizer in CCMS (Oracle)

Leaving content frame