Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: NOT IN conditions are extremly SLOW
Please read up Thomas Kyte on NOT IN.
If the column in the master table is NULL allowed, this will force CBO
to disregard indexes and CBO won't perform an ANTI-JOIN.
-- Sybrand Bakker Senior Oracle DBAReceived on Thu Oct 06 2005 - 03:08:40 CDT