SAP Knowledge Base Article - Preview

2156960 - Performance issue with queries using a large IN list - SAP ASE for Business Suite


  • 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


SAP Adaptive Server Enterprise 15.7


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.