|Subject||RE: [firebird-support] in vs exist|
> Season Greetings everyone!to quote Celko
> Can anybody give me somes notes on uses of "IN" and "EXIST". How are
> they being use? Which is much preferred?
"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