Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 29 Aug 2003 @ 13:34:27 GMT


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


Subj:   Re: Join Order In Teradata
 
From:   Kohut, Eric J

Another case is if you are referring to Outer Joins.

The order of outer joins should always affect the optimization path because the order does matter.

But if your issues is with inner joins, the where clause syntax should be less prone to affecting order.

This will be fixed in V2 R5.02 as was mentioned.



     
  <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