Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 31 Mar 2007 @ 20:07:31 GMT


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


Subj:   Re: Order of inner joins alter plan
 
From:   Anomy Anom

<-- Anonymously Posted: Saturday, March 31, 2007 13:24 -->

  At one time there was a discussion thread on the different plans from the original syntax versus the join syntax. However, I seem to remember Todd Walter posting a message regarding the fact that developers realized there was a difference and were in the process or planning to fix it. Since that was quite some time ago, I am sort of hopeful that it has already been corrected.  


I'll agree, my understanding is that changing the order of joins or where predicates should not change the execution plan. I also recall hearing that if anyone found this kind of behavior, Teradata wanted to know about it. I'd suggest submitting the queries as a priority 3 incident - along with the appropriate supporting info (TSET).



     
  <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: 23 Jun 2019