Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 01 Jun 2012 @ 21:05:43 GMT


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


Subj:   Re: Where NULL values will store while joining
 
From:   Walter, Todd

And look at the plan. If you are doing a join on a nullable field, the optimizer will qualify out the rows with nulls when they cannot contribute to the result.



     
  <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: 28 Jun 2020