Subject Re: [firebird-support] Indexes or Tables?
Author Helen Borrie
At 05:52 AM 26/10/2004 -0300, you wrote:

>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?

Well, you can include your own PLAN clause in the statement, but I prefer
to play around with the query until the optimiser generates a plan that
works fast and looks like my plan.