Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 29 Jul 2003 @ 21:35:53 GMT


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


Subj:   Re: Left Outer Join and Explain Plan
 
From:   Aniruddha Mitra

Hi:

Thanks for your reply. each of the query has one outer join. The forst query has one more inner join, and the second query has one more left outer join instead of the inner join. According to the theory, query with 2 outer join should take less time compared to a query with one outer and one inner join. However, in practice, the query with 2 outer joins runs in 20 sec, and with one outer, and one inner join runs out of spool after some time (245 sec). This is strange.

I also believe that the result sets are by chance same, and they may not be same all the time.

Aniruddha



     
  <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