SAP Knowledge Base Article - Preview

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

Symptom

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.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

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.