How to use DB20 - Update DB Statistics

SAP Transaction Code - Details

• Transaction Code: DB20

  Description: Update DB Statistics

  Release: S/4HANA and ECC 6

  Menu Path:

  • Tools > CCMS > DB Administration > Cost-Based Optimizer > Create Statistics

• • Program: SAPMSTRD

    Screen: 1100

    Authorization Object: S_ADMI_FCD

  • Development Package: SDBA

    Package Description:

    Parent Package:

  • Module/Component:

    Description:

Smart SAP Assistant

• SAP Tcode: DB20 - Update DB Statistics

  
  Overview:
  The SAP transaction code DB20 is used to update database statistics. This is an important task for maintaining the performance of the database. It helps the system to optimize the access paths and query execution plans. 
  
  Functionality: 
  The DB20 transaction code allows users to update the database statistics in order to improve the performance of the system. It also helps to identify and resolve any issues related to database performance. The statistics are updated by running a program that collects information about the database structure and usage. 
  
  Step-by-step How to Use: 
  1. Log into the SAP system and enter transaction code DB20. 
  2. Select the database you want to update from the list of available databases. 
  3. Select the type of statistics you want to update (e.g., table, index, etc.). 
  4. Select the tables or indexes you want to update. 
  5. Click “Execute” to start the update process. 
  6. Once the process is complete, click “Back” to return to the main screen. 
  
  Other Recommendations: 
  It is recommended that users regularly update their database statistics in order to maintain optimal performance of their system. Additionally, users should be aware that updating database statistics can take a long time depending on the size of the database and number of tables or indexes being updated.