Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 21 Jul 2004 @ 00:57:40 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Why NOT EXISTS is faster than NOT IN
 
From:   Christie, Jon

You can probably see why if you get explains and examine them carefully. Both NOT IN and NOT EXISTS will trigger an exclusion join. Are any of the columns involved nullable? If so, it will probably make NOT IN run slower.


Jon



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016