Hi Experts ,
Can somebody please tell me where summary stats are stored . Thanks in advance .
Not pretty sure of the question. You can refer to this wonderful blog of Dieter:
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
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 .
From the doc:
The stats created by "COLLECT SUMMARY STATS" are also stored in the 'Histogram' column of dbc.StatsTbl with StatsId = 0