All Forums Database
teradata_chela2 18 posts Joined 10/13
28 Dec 2014
Where summary stats are stored

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

Arint

Raja_KT 1246 posts Joined 07/09
28 Dec 2014

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 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

teradata_chela2 18 posts Joined 10/13
29 Dec 2014

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 .

Arint

Raja_KT 1246 posts Joined 07/09
29 Dec 2014

From the doc: 
http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1142_111A/ch02.124.098.html
 

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.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

teradata_chela2 18 posts Joined 10/13
29 Dec 2014

Thank you very much ..

Arint

dnoeth 4628 posts Joined 11/04
30 Dec 2014

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

Dieter

You must sign in to leave a comment.