Subject Re: [firebird-support] Re: Bug in firebird 1.5?? left joining
Author Arno Brinkman

> > > select a.* from a where
> > > not exists(select * from b where =
> >
> > Yes, this should be equivalent and probably faster when there are
> many
> > duplicates on the person field.
> Thanks for the info. Is there any perfomance difference between the
> above query and:
> select a.* from a where not in (select id from b)
> The plans look the same, but my test tables are too small to show any
> difference is speed.

Internally a IN predicate with sub-select is converted to the same as a
EXISTS thus there should be no performance difference between those two.

Arno Brinkman

Firebird open source database (based on IB-OE) with many SQL-99 features :

Support list for Interbase and Firebird users :

Nederlandse firebird nieuwsgroep :