Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 15 May 2009 @ 09:48:00 GMT


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


Subj:   Re: Pls Explain the Explain Plan
 
From:   Swartzbaugh, Jason

Do you mean that the join order in the explain plan does not match the order in which the joins were written in your query? This is probably not a problem -- although it's difficult to say for sure since you have not included the full explain text.

The optimizer's job is to determine the most efficient way to answer the query that was submitted. Sometimes this means changing the join order, because it is more efficient.


Regards,

Jason Swartzbaugh
Sr. Benchmark Analyst
Teradata Corporation



     
  <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