Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 24 Jan 2012 @ 14:54:19 GMT


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


Subj:   Dropping stats and collecting PI stats
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, January 24, 2012 09:44 -->

2 little questions regarding Stats

* Under what conditions is it worthwhile dropping stats in Teradata - some candidates to me are e.g., after migration or reconfiguration or adding node etc.

* If the demographics of a column that is not part of hashing change e.g. suddenly N ulls get replaced by default values in a column that is not hashed for distribution , then my understanding is - there is no need to collect the stats on the pi or Ix cols. Only take stats on that col. that changed. Just need a 'nod' or 'not' on that



     
  <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