Helen Borrie wrote:

>When you are using status flags to select rows, it's usually necessary to
>provide the classic workaround to low selectivity problems on indexes over
>these flags: defining an index consisting of (Flag, PrimaryKey) and, if
>the flags themselves are foreign keys, to adjust query plans to block use
>of the FK index and enforce using of the user-defined one.
>
>./heLen
>
>
>

How do you enforce plans to use the user-defined index?

TIA.

German.