 |
 |
Archives of the TeradataForum
Message Posted: Thu, 20 Mar 2008 @ 11:05:43 GMT
| 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
| |
