Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 04 Apr 2008 @ 12:28:09 GMT


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


Subj:   Re: No Stats better then Current Stats?
 
From:   william.gregg

If U are new to Teradata really honor the posting advice about the helpstats diagnostic.

"But later while implementation don't collect all the recommended ones."

The diagnostics tool will recommend collecting many stats that U�re applications don�t need.

Also, be aware of any tables that grow and shrink (maybe even emptied) on a regular cycle.

Mis-timed stats will give the wrong picture to the Optimizer.

Good Luck!


Rgrds,

Bill Gregg
Teradata Team
Thomson Healthcare



     
  <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