Database

turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

12-28-2014
09:52 PM

12-28-2014
09:52 PM

Hi Experts ,

Can somebody please tell me where summary stats are stored . Thanks in advance .

5 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

12-28-2014
11:04 PM

12-28-2014
11:04 PM

Not pretty sure of the question. You can refer to this wonderful blog of Dieter:

http://developer.teradata.com/blog/dnoeth/2013/08/new-statsinfo-query-for-td14

After obtaining the details of summary , you can see the summary stats too with

show summary statistics on yourdbnameyyyyyyy.tabelnameyyyy or

show summary statistics values on yourdbnameyyyyyyy.tabelnameyyyy

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

12-29-2014
07:16 PM

12-29-2014
07:16 PM

Hi Raja ,

Thanks for your reply . Like stats and histograms have their table in TD14 where summary stats are stored ?

Are they stored in table header or in the statsinfo table .

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

12-29-2014
10:04 PM

12-29-2014
10:04 PM

From the doc:

Summary statistics are recorded in the histogram header. The header records the following information.

•Collection timestamp

•Statistics version

•Sampling percentage (if the summary statistics were collected by sampling)

•Number of columns

•Number of high‑biased values

•Number of equal‑height intervals

•Number of history intervals

•Number of AMPs

•Number of nulls

•Number of all nulls

•Average AMP NUSI rows per value

•Total number of values and total number of values from partial nulls

•Total number of rows

•High modal frequency

•Offset to the column descriptor

•Offset to the minimum value

•Offset to the high modal value

•Beginning offset to the histogram intervals

•Ending offset for the histogram intervals

•Size of the histogram header

note: I have less idea on this topic.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

12-29-2014
11:41 PM

12-29-2014
11:41 PM

Thank you very much ..

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

12-30-2014
03:40 AM

12-30-2014
03:40 AM

The stats created by "COLLECT SUMMARY STATS" are also stored in the 'Histogram' column of dbc.StatsTbl with **StatsId = 0**

Copyright © 2004-2015 Teradata Corporation. Your use of this Teradata website is governed by the Privacy Policy and the Terms of Use, including your rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.

The Privacy Policy and Terms of Use for this Teradata website changed effective September 8, 2016.