Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 04 Feb 2004 @ 00:21:32 GMT


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


Subj:   Re: Query Performance
 
From:   Christie, Jon

I suspect the main thing that is wrong with the original plan is that there were a bunch of terms on the right table in the nested join and they could not be applied until the following rowid join step. The actuall size of the spool that's the result of the nested join is much larger than estimated.

The optimizer used to fall into this trap all the time in release 4, but in release 5 it's much smarter - at least on this issue. What release are we running here? I don't think it 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