Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 18 Jun 2014 @ 21:13:29 GMT


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


Subj:   Re: SQL with product join
 
From:   Dieter Noeth

There's no way to remove this. Any ORed join condition will always be a product join, because the optimizer needs to know which AMP processes the join. The PI columns must be hashed to determine the AMP and only ANDed conditions can be hashed.

But this join looks quite strange, it's not a common equi-join, what is this user trying to do?

Can you show the full SQL?


Dieter



     
  <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: 15 Jun 2023