Hello SAP Users,
Can anyone tell me that how do I create new SQL optimizer statistics?
I need to know it urgently so please tell me the solution for my query and help me out by your valuable comments.
In the SAP environment, we recommend that you use the DBA Planning Calendar (transaction DB13) or the DBA Cockpit (transaction DBACOCKPIT) to update the optimizer statistics.
SAP Release lower than 7.0:
You can use the actions Create New Optimizer Statistics (UPD_UNCOND), Check Optimizer Statistics (UPD_CHECK) and Refresh Optimizer Statistics (UPD_COND) to check and recreate the statistics.
SAP Release 7.0 or higher:
The actions Update All Optimizer Statistics (UpdAllStats), Select Tables for Update Statistics (PredUpdStat) und Update Statistics for Selected Tables (UpdStats) check and recreate the statistics.
Sign up for STechies