|Subject||Re: Basic SQL Update query question|
>Give the optimiser some credit. Under FB 1.5 and higher, they pretty
> Well, others gave you the solution with IN, but that is not "the best
> way", as IN can be much slower than EXISTS:
much always use the same plan (internally converted to exists). I am
yet to see a case where they don't (although I imagine with some
complex aggregates it may possibly not convert).