SAP Knowledge Base Article - Preview

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.

 Improved.png


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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.