Subject RE: RE: RE: [firebird-support] Re: Possible to write this in a way that indices will be used
Author Maya Opperman
>Set Wrote:
>However, if I specify the plan:
>Select <whatever>
>From tablea a
>Where a.VerySelectiveField between :fromvalue1 and :tovalue1
> And a.AlmostAsSelectiveField between :fromvalue2 and :tovalue2
>PLAN (A INDEX(IndexVerySelectiveField, IndexAlmostAsSelectiveField))
>then the performance is decent in both cases, although not as excellent
as if the best plan had been chosen depending >on the parameters.

Sounds good. To help me understand better, what exactly am I telling FB
to do here though? Use both indexes simultaneously?