Symptom
- Query with large in-list performs poorly.
- set statistics time may display a large value in Parse and Compile Time (the number of CPU ticks taken to parse, optimize, and compile the query) for the query.
- set showplan may display "OR List has up to <a large value> rows of OR/IN values" in SCAN Operator.
Read more...
Environment
- Adaptive Server Enterprise 15.7
- Adaptive Server Enterprise 16.0
- "Statement Cache" is enabled
- "Literal Autoparam" is enabled
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
sybase, adaptive server, performance, elements, list, p&t, compile, COMPILING, slow, constant , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.