All Forums Database
Moutusi 38 posts Joined 03/13
05 Nov 2014
Summary Statistics

Hi,
What are differences between summary statistics and satistics? When we should opt for summary statistics instead of statistics?

Thanks, Moutusi
Raja_KT 1246 posts Joined 07/09
05 Nov 2014

Summary stats is quite fast and generate details like row count,block size..... I think it is collected automatically once you generate stats.
Normal stats takes more time.

It is suggested to do for both. Summary stats is getting details quickly like for row count....

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.

abhishek.jadhav 28 posts Joined 02/08
06 Nov 2014

The Summary statistics are collected automatically when statistics on any column of the table are collected.

You may refer the orange book "TD14.10 Statistics enhancement". It has very good information.

 

 

~ Abhishek Jadhav

Thanks
Abhishek Jadhav

Moutusi 38 posts Joined 03/13
07 Mar 2015

If I 1st time I collect stats on required columns and after that wheneer table gets refreshed I do summery stats onl will it refresh the column level stats also which I have collecte in 1st pace?

Thanks,
Moutusi

SmarakDas 51 posts Joined 02/12
09 Mar 2015

Hello Moutusi,
After Summary Stats has been collected for the 1st time, then collecting any column level statistics will refresh the Summary Stats implicitly. The vice versa isn't true meaning Refreshing Summary Stats doesn't refresh any Column Level Stats.

You must sign in to leave a comment.