What are differences between summary statistics and satistics? When we should opt for summary statistics instead of statistics?
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?
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.