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