Re: optimal sql

Not exists stops when it finds the first match and not in gets the whole list.
Jim
"Christoph Seidel" <chris666.seidel_at_gmx.de> wrote in message news:at1ufn$vjojo$1_at_ID-143718.news.dfncis.de...
> Martin Doherty wrote:
> > NOT IN becomes very inefficient for many values.
> >
> > try NOT EXISTS instead.
>
> hm, where the hell is the difference?
>
>
Received on Mon Dec 09 2002 - 09:35:10 CST