Subject Re: [firebird-support] Re: Subset query
Author Dimitry Sibiryakov
On 8 Mar 2006 at 16:54, willy_metra wrote:

>Both where-fields are indexed, but the problem is that the first
>where-predicate is done very quickly due to short condition range,
>it's just 10 mins. But the second one is very long, cuz it's going
>through the whole db.

I'd sugest to drop the second index.

--
SY, Dimitry Sibiryakov.