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:11:33 -0700
Message-ID: <1128586293.114738.202560@g49g2000cwa.googlegroups.com> 





Did you run EXPLAIN PLAN? The subquery will perform a full table scan,
as there are no useful predicates in it.



Your generic assertion 'NOT IN conditions are extreemly slow' is way
exaggerated.


They don't need to provide, the affected columns are indexed and
*mandatory*.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Thu Oct 06 2005 - 03:11:33 CDT












Original text of this message













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