Subject RE: [firebird-support] in vs exist
Author Alan McDonald
> Season Greetings everyone!
> Can anybody give me somes notes on uses of "IN" and "EXIST". How are
> they being use? Which is much preferred?
> Thanks

to quote Celko
"An EXISTS predicate can use indexes to find.. or fail, whereas the IN
predicate ofen has to build the results of the subquery in a working table"

not sure exactly how FB is optimised in this regard