Use the CCMS for checking and updating statistics for the Oracle cost-based optimizer (CBO).

The SAPDBA menu option DB Optimizer control (SAPDBA menu Additional functions) is another way of displaying statistical information, checking the requirements for new statistics in online mode, deleting superfluous statistics, and creating missing statistics.

Function: Show all statistics information

This display tells you how many tables or indexes of the user SAPR3 have no statistics, and how many tables entered in the control tables DBSTATC have obsolete statistics (TODO indicator in DBSTATC).

It also gives you information about the number of tables entered in control table DBSTATC, the number of tables explicitly excluded from the statistics (Active = N), the number of tables and indexes excluded from the CBO statistics (Active = R or N), and the number of tables that are marked with a customer indicator in the control table (..user defined values).

Function: Check for new statistics

You can use this check either for a single table, for all the tables of a certain tablespace, or for all the tables of the control table. You can specify the threshold for the percentage change in table records from which the statistics are considered obsolete (menu option a). You can also restrict the check to a certain period of time (menu option c). However, you should not normally set a time limit.
A Forced check (menu option b) updates the entries in the control table, independently of the current status; this means that all existing TODO indicators are reset.

Function: Delete statistics excluded for R/3

Deletion of tables not required for the R/3 System, for example pool and cluster tables or tables marked as such in the control table DBSTATC (Active = N or R).

Function: Create missing statistics for all tables and indexes

When, for example, you add one or more new tables or indexes, you can easily create statistics for them using this menu option.