Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 29 Jan 2015 @ 20:50:24 GMT

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

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.



  <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