Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 28 Aug 2003 @ 13:27:41 GMT


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


Subj:   Join Order In Teradata
 
From:   Dave Harper

Greetings All:

I had a general question regarding how/why Teradata is join order specific. I hadn't been aware that table ordering in my join condition would have an impact on the query plan that is generated -- I know it isn't like that in SQL Server and I believe Oracle. Is this done for MPP so that each spool can be merged more easily dependant upon the data it retrieves?

Is there a way to determine the best 'order' to join tables? Or is it more trial and error?


Thanks in advance.

Dave Harper



     
  <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