Standard Operations for CBO Statistics 

Use

Execute the most important actions for updating statistics in the CCMS (Transaction DB20). If you have created new tables or executed a large data transfer, you must create the missing statistics or update the current statistics in addition to the normally scheduled statistic operations.

Features

Choose Tools ® CCMS ® DB Administration ® Cost-based optimizer ® Create statistics. Alternatively, call Transaction DB20.

Then choose Standard operations. Choose between the following functions:

Analyzes all database tables ( PSAP%) to determine which tables need statistics. It then updates the corresponding entries in the control table DBSTATC .

Creates current statistics for all tables whose TODO flag is set in the control table DBSTATC . This implicitly creates statistics for all tables and indexes which do not have statistics.

Creates statistics for all tables and indexes which do not have statistics.

Deletes illegal statistics.

Choose Start to activate the function selected.