Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 30 Jan 2015 @ 22:24:35 GMT


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


Subj:   Re: TD14 Optimised stats collection
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, January 30, 2015 17:08 -->

Martin,

With the variety of statistics options now available any legacy code and tables should be reviewed on a case-by case basis.

For example, before you go down the rolled up single scan statistics path I recommend you also investigate use of the simple 'COLLECT SUMMARY STATISTICS ...' route as well.

Our experience with the former is that of spool and containment issues on large tables whereas simply collecting the 'instant' SUMMARY statistics has saved us millions of CPUs with no loss in throughput. In many cases this has speeded up processes dramatically. Explain query paths are much the same.

This is especially true on intermediate work tables.



     
  <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: 27 Dec 2016