Database

turn on suggestions

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

Showing results for

- 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**