Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 02 Apr 2003 @ 18:18:32 GMT


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


Subj:   Re: V2R5.0 release summary terms
 
From:   Loomis, Ernie

Block optimization in the Release 5 context refers to the way the optimizer works. Previously the optimizer looked at subqueries, derived tables, views as separate "blocks" of work and optimized independently. You might have a highly selective WHERE in the main query that would reduce the data spooled in the subquery, but the subquery "block" optimization did not recognize that. With R5, the full query is examined for possible cost savings



     
  <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