Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 28 Jul 2010 @ 17:15:48 GMT


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


Subj:   Re: Use of Derived Tables
 
From:   John_Wight

That was only true for V2R4 (I believe) in 2.5 and beyond, you could not 'control' that anymore without having to specify an option somewhere (can't remember that far back). In TD 12 and beyond, the queries can actually be 're-written' at execution time. Yeah - it was great for a while, but then it's always been the optimizers 'domain' to control the way it wants to execute - and in general, it's done a good job!


JK



     
  <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: 23 Jun 2019