Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 20 Mar 2008 @ 11:05:43 GMT


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


Subj:   Re: Sampled Statistics Information
 
From:   John Hall

Janardhan Ramchandran wrote:

  I need to know whether we can get this information from the dbctables, without using the statistics wizard.  



You might have missed this post:


Anomy.Anom wrote:

  Check the attachment archives at teradataforum.com for some queries / views (supplied by Dieter Noeth) that expose more of the stats info stored in the dictionary tables. SampleSize is the percentage; 100 for full stats, less for sampled.  


The attachment ('Statistics.sql') can be found at:

www.teradataforum.com/attach.htm



     
  <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