Subject Re: [firebird-support] Indexes or Tables?
Author German Pablo Gentile
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.
How do you enforce plans to use the user-defined index?