Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 08 Jan 2004 @ 00:41:19 GMT


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


Subj:   Re: View Performance
 
From:   Victor Sokovin

Jon,

  There is a transitive term to be derived here:  


  RECJOB.JOB_ID = RECMTD.JOB_ID  


  This term would allow the optimizer to consider joining RECJOB to RECMTD. That may or may not be a wonderful thing, but as the request was originally coded, that join would not even be considered. When the request is re-coded as above, the join would be considered.  



Could you clarify this part for me? Are the following points correct:

1. It was the intention for the optimizer to always consider the transitive closure for inner join predicates. Because of the bug you mentioned only the 'old fashioned' syntax will be parsed as desired. ANSI 'JOIN' syntax implies no transitive closure.

2. Transitive closure will not be used for outer joins, and the bug does not affect that.


Regards,

Victor



     
  <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