- 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?
SAP Adaptive Server Enterprise 15.7 SP 141
SAP Adaptive Server Enterprise 15.7
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this pageThis 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.