A SQL query on an SAP ASE server (eg: ASE1) runs slow due to a sub-optimal access plan generated by the ASE optimizer.
The same query runs fast on a different ASE server (eg: ASE2) where the table contents differ. ASE generates a good access plan on this second server.
Statistics for the table are up-to-date on both ASE servers.
You want to load statistics from the ASE2 to ASE1 to overcome the query performance issue.
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
slow, query, performance, statistics, "query plan", optdiag, import, export , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.