2370834 - The value of the selectivity of the IN clause is very low - SAP IQ

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.

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.