Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 30 Mar 2007 @ 23:02:41 GMT


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


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

<-- Anonymously Posted: Friday, March 30, 2007 16:57 -->

In regards to the question about the order of inner joins altering an explain plan, I seem to recall that the optimizer has occasionally acted differently depending on whether you code in ANSI syntax specifying "INNER JOIN" vs coding in Teradata syntax using commas. Could that be related to this question, and has anyone else had that experience?


Thanks, Anomy



     
  <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