 |
 |
Archives of the TeradataForum
Message Posted: Thu, 29 Jan 2015 @ 20:50:24 GMT
| Subj: | | Re: TD14 Optimised stats collection |
| |
| From: | | Martin Barrow |
Dimitrios Kostakis-Kostas wrote:
| | 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. | |
We do have the metadata control tables for our automated stats collection, I was just using the dynamic build from the DBC table as an example.
We understand the other options of doing a full table collects stats and when stats need to be refreshed - but the full table refresh it not
suitable in this instance.
To clarify, I am just looking at ways to dynamically build the optimised collect stats statement as opposed to the single collect stats
statements from metadata (either control table or DBC). Maybe a SP and cursor maybe my best option.
Regards,
Martin
| |
