 |
 |
Archives of the TeradataForum
Message Posted: Thu, 29 Jan 2015 @ 13:57:33 GMT
| 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.
| |
