- 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).
SAP Adaptive Server Enterprise (ASE) 15.7 SP132 and higher for Business Suite
CR782645, CR#782645, 782645 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed
About this pageThis 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.