"Alexandre Benson Smith" <iblist@...> wrote:

>
> Wouldn't it be the same as the original query ? (Because IN is converted
> to EXISTS internally)

Nope. IN and EXISTS always deliver the same result and internally executed
similarly. But this is untrue for NOT IN vs NOT EXISTS - they're different!
Also, they're differently optimized by v2.0.


Dmitry