Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 28 Jul 2010 @ 17:17:04 GMT


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


Subj:   Re: Use of Derived Tables
 
From:   frank.c.martinez

An effective way to let the optimizer do its job is to make sure the proper statistics are taken and possibly to instantiate derived tables as real or volatile tables. If you've got control of the SQL (say you're not running a tool that generates it), break the SQL down until it does what you need.


iv



     
  <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