The end-user has created a HG index on the column.
However, the value of the selectivity of Condition 3 is very low.
Condition 3 Selectivity
I want to know why the optimizer did not use an effective meta data from the HG index.
Selectivity of Condition1 and Condition2 also value is low…
As a result, IQ optimizer does not select the optimal plan.
If they specify a hint to the IN clause, the processing speed of this Leaf node is improved.
SAP IQ 16.0 SP08 PL32
KBA , BC-SYB-IQ , Sybase IQ , Problem
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.