Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 29 Jan 2004 @ 22:17:08 GMT


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


Subj:   Re: Statistics and explain plans
 
From:   Christie, Jon

I was using the word distribution in the narrow sense of how rows are distributed across the amps. You're right about that. And statistics (in the narrow meaning of Teradata statistics) contain no information about that.

Taradata statistics are global.

There is a popular misconception that you need to re-collect statistics if you reconfig to add (or remove) amps. Not true. A reconfig does not change your data, it just moves it around. If your data has not changed, you don't need to re-collect stats.


Jon



     
  <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