Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 06 Mar 2002 @ 15:02:35 GMT


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


Subj:   Re: What information does 'collect statistics' store?
 
From:   James A. Judge

There is a freeware tool called Interastats,"... inTERAstats is a tool for DBAs and SEs to display and analyze statistics gathered by the COLLECT STATISTICS command. Many statistics are gathered and stored in the catalog but the user is unable to view them. The only statistics provided are the numbers of unique values in the domain of a column or index. inTERAstats explodes this to the full number of intervals, with interval modal frequencies, minimum and maximium values and non-modal row counts. These are valuable in determining the domain uniformity, sparseness, and to get a quick glimpse of its value type. inTERAstats will print all statistics displayed. ...." check it out at,

www.members.rogers.com...



     
  <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