SAP Knowledge Base Article - Preview

2788243 - Import table statistics to resolve slow query performance - SAP ASE for Business Suite


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


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


slow, query, performance, statistics, "query plan", optdiag, import, export , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To

About this page

This 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.