RECOMMENDATIONS FOR PRODUCTION OPERATION

In production operation, we strongly recommend you to update statistics at least weekly using the DBA
Planning Calendar (that is, transaction DBACOCKPIT or DB13). For Oracle 10g we recommend you to do
this even daily. We provide several action patterns that include a weekly or daily run of update statistics.
If you use a tool such as cron (UNIX) or at (Windows), we recommend the following standard command:
brconnect -u / -c -f stats -t all
We recommend you to normally use the above method to update statistics.
We also recommend you to use this call immediately after a SAP System upgrade or after a
large amount of data has been changed in the database.
In the above call, BRCONNECT checks statistics for all SAP tables and indexes using the standard method.
If the change threshold for a particular table is exceeded, statistics are updated for that table.
BRCONNECT also deletes damaging statistics. For more information, see "Delete damaging statistics" [page
19] below.
The following are further examples of update statistics commands:
 Update (that is, create) statistics only for tables and indexes with missing statistics
brconnect -u / -c -f stats -t missing
 Check and update statistics for all tables specified in the DBSTATC table
brconnect -u / -c -f stats -t dbstatc_tab