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
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.