Hey Set!

> Mitch' 'problem' is that he uses OR EXISTS(<subquery referencing

fields in

> the outer select>)..., which forces Firebird to examine every record

of

> Deal anyway and makes it impossible for Firebird to benefit from an

index

I agree. I missed the "OR" when I wrote my later reply.

> I'm sorry to say that I'd be shocked if your two latest
> suggestions below would change the plan to anything better.

I concur!


Sean