SAP Knowledge Base Article - Preview

3210498 - Query using merge-join has performance issues - SAP ASE

Symptom

  • Query running slower and using a less efficient plan:
  • Observations are:
    • MRU rather than LRU.
    • Nested Loop Join is now Merge-Join.
    • But the default data cache is configured as LRU.
  • Why is the plan changing for this data set?


Read more...

Environment

SAP Adaptive Server Enterprise 15.7 SP 141

Product

SAP Adaptive Server Enterprise 15.7

Keywords


query performance, merge join, nested loop join, optimizer issue, data cache, LRU, MRU, temporary table, query execution plan, abstract plan, database performance, query optimization, SQL performance , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.