|Subject||RE: RE: RE: [firebird-support] Re: Possible to write this in a way that indices will be used|
>Set Wrote:as if the best plan had been chosen depending >on the parameters.
>However, if I specify the plan:
>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
Sounds good. To help me understand better, what exactly am I telling FB
to do here though? Use both indexes simultaneously?