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