How to use CNV_10020_UPD_STATS - Refresh of optimizer statistics

SAP Transaction Code - Details

• Transaction Code: CNV_10020_UPD_STATS

  Description: Refresh of optimizer statistics

  Release: S/4HANA and ECC 6

• • Program: CNV_10020_UPDATE_STATS

    Screen: 1000

    Authorization Object:

  • Development Package: CNV_10020

    Package Description: CNV package 10020

    Parent Package: DMIS_BASIS_CWB

  • Module/Component: CA-LT

    Description: Landscape Transformation

Smart SAP Assistant

• SAP Tcode: CNV_10020_UPD_STATS - Refresh of optimizer statistics

  
  Overview:
  CNV_10020_UPD_STATS is a SAP transaction code used to refresh the optimizer statistics of a database table. This transaction code is used to ensure that the optimizer has up-to-date information about the data stored in the table, which helps it to make better decisions when executing queries. 
  
  Functionality: 
  The CNV_10020_UPD_STATS transaction code is used to update the optimizer statistics of a database table. This includes information such as the number of rows in the table, the number of distinct values in each column, and other statistical information. This information is used by the optimizer to determine the best way to execute queries on the table. 
  
  Step-by-step How to Use: 
  1. Log into your SAP system and navigate to transaction code CNV_10020_UPD_STATS. 
  2. Enter the name of the database table for which you want to refresh the optimizer statistics. 
  3. Select “Refresh” from the dropdown menu. 
  4. Click “Execute” to start refreshing the optimizer statistics for the selected table. 
  5. Once complete, you will see a confirmation message that the optimizer statistics have been successfully refreshed. 
  
  Other Recommendations: 
  It is recommended that you refresh the optimizer statistics for your database tables on a regular basis, as this will ensure that your queries are executed in an optimal manner. Additionally, it is important to note that refreshing optimizer statistics can be a time-consuming process, so it should be done during periods of low usage or at off-peak times.