Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 19 Mar 2008 @ 14:00:12 GMT


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


Subj:   Re: Sampled Statistics Information
 
From:   Koneru, Rajesh

Currently the only roundabout way is to find the distinct values on the table and match the number against that produced from the help stats command.

For some important enterprise tables it is a general strategy to use an indicator field to be flipped whenever the data is loaded and flipped back as soon as the stats are collected on the same (after the 10% increase in volume). This indicator can be directly used to validate stats being current or stale on the table.

As noted in the manuals stats need to be refreshed only if the data changes amount to 10% volumes or more and so the stats could date back in time for some relatively slow loads (where incremental changes are not many).


Thanks & Regards,

Rajesh
Contractor - TCS



     
  <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: 27 Dec 2016