When a large number of IN clauses are specified with "OR", the performance of IQ16.1 is much lower than that of IQ 16.0 SP08.
Elapsed Time (sec)
16.0 SP08 -- 128.4sec
16.1 SP02 -- 1,366.7sec
You can check if the conditional statement is split by query plan.
The condition is divided and evaluated as (Part1, Part2 ... Part999).
The optimizer does not split the condition.
This line occurs when the split condition is included in the SQL statement.
- SAP IQ 16.0 SP11 and later
- SAP IQ 16.1
16.0, 16.1, IN, split, condition, part1, Invariant Condition, performance, down , KBA , BC-SYB-IQ , Sybase IQ , 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.