> No, I cannot unless you tell me what you're trying to do.

Sure, here we go...

I'm trying to do:

select
*
from
TABLENAME
where
(INDEXEDFIELD1 > '8.3.2006 00:00:00' and INDEXEDFIELD1 < '8.3.2006
00:10:00') and INDEXEDFIELD2 < '8.3.2006 00:00:00'

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. So i'm trying select the first subset via the
first where-predicate and than apply the second where predicate on
the selected subset.

Thank you for any kind help.