Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 29 Jan 2015 @ 13:57:33 GMT


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


Subj:   Re: TD14 Optimised stats collection
 
From:   Kostakis-Kostas, Dimitrios

Robert Briggs wrote:

  There are several instances where this is not the case, one of them being a restore from tape when the original archive did not include stats information.  


Hi ,

Ok, but if td is not keeping the info , you mean keeping the info of stats before restoring and apply them after ,on this case yes . Generally, on my opinion you must keep a metadata table which keeps all the collection of stats, number of rows, in order to be able to check if 10% change is accurate , in order to take correct decision about the frequency of collection.



     
  <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