Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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:


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020