SAP Knowledge Base Article - Preview

2895200 - Performance issue with split IN clause - SAP IQ

Symptom

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.

tempsnip.png


Read more...

Environment

  • SAP IQ 16.0 SP11 and later
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

16.0, 16.1, IN, split, condition, part1, Invariant Condition, performance, down , KBA , BC-SYB-IQ , Sybase IQ , 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.