Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 23 Apr 2004 @ 15:42:33 GMT


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


Subj:   Left Outer Join on Partition (PPI) table
 
From:   Sada Shirol

Hi everyone: We are seeing incorrect results with Left Outer Join on a partition (PPI) table that is access by non-partition column resulting in row hash match scan. However, we see correct results when an outer join is used on partition table and is accessed by partition columns. It both the cases explain shows optimizer is using merge join. We are on V2R.05.00.01.05 Any insight/possible work around would be greatly appreciated.

Sada Shirol



     
  <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