Checking and Updating Statistics for a Single Table: Oracle 
Prerequisites
Use this function only when you determine there is an immediate need for updated CBO statistics for a particular table.
For example, use this function when:
Procedure
1. Choose Tools ® CCMS ® DB Administration ® Cost-based optimizer ®
Create statistics. Alternatively, use Transaction DB20.2. Enter the name of the table (do not enter a generic name or pattern) and choose Refresh information.
3. Choose Number of table entries to determine whether the table’s CBO statistics need refreshing. Then do the following:
– Confirm the warning message. Depending upon the size of the table, this check may take a few seconds or up to several minutes or even longer.
– After the check is complete, look at the field Deviation old/new. The contents of this field indicate how the CBO statistics deviate from the current table status. If the deviation is 10% or greater, update the statistics for the table. Otherwise, the deviation between the CBO statistics and the actual state of the table is not significant enough to require new statistics.
The field Old value displays the number of table entries before the statistics were created. The field New value, displays the current number of table entries.
4. Do the table’s statistics need to be refreshed? If yes (deviation ³ 10%), do the following:

If the runtime is acceptable, choose High accuracy.
The R/3 System updates the CBO statistics for the table as well as the fields Time and Date.
This action does not add the table to the control table
5. Do the table’s statistics need to be deleted? If yes, choose Delete statistics.
For more information, see
Updating Optimizer Statistics Automatically (Oracle)