Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 20 May 2009 @ 15:57:34 GMT


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


Subj:   Re: Pls Explain the Explain Plan
 
From:   Michael Larkins

Chaithanya:

The only explanation is that you wrote your SQL join incorrectly. The optimizer is fixing the plan to be efficient, unlike your SQL which joins tablea first.

It might be that the PIs of tablec and tabled are used in the join. Otherwise, they may be the smallest tables. Regardless of the reason, you did not write optimal SQL so the optimizer is doing the job correctly for you. You can be happy about this capability.


Regards,

Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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