On 11/24/2010 08:35 PM, Jasen Betts wrote:
> all examples untested
>
> eg "NOT IN":
A word of caution: according to my experience, "NOT IN" exhibits much
stronger inclination to produce sequential scan plans than "NOT EXISTS".
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com