Symptom
- A simple query with a large IN list (for example 158 values in the list) chooses a sub-optimal index.
- Same query with a smaller IN list (for example 20 values) can use an optimal index.
- Execution time is six times higher between first query and second query (for example 3042263 milliseconds versus 571545 milliseconds).
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 SP132 and higher for Business Suite
Product
SAP Adaptive Server Enterprise 15.7
Keywords
CR782645, CR#782645, 782645 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed
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.