Symptom
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 |
0.00064449 |
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.
Read more...
Environment
SAP IQ 16.0 SP08 PL32
Product
SAP IQ 16.0
Keywords
KBA , BC-SYB-IQ , Sybase IQ , 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.