Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: NOT IN conditions are extremly SLOW

Re: NOT IN conditions are extremly SLOW

From: <sybrandb_at_yahoo.com>
Date: 6 Oct 2005 01:08:40 -0700
Message-ID: <1128586120.480488.118010@o13g2000cwo.googlegroups.com>


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 DBA
Received on Thu Oct 06 2005 - 03:08:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US