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: 24 Jul 2020