December 17, 2009 at 1:05 pm
I have read considerably about this subject and seen many different opinions.
If someone is an authority on this subject, I'd like to know conclusively:
1. Does rebuilding indexes also update data distribution statistics? Or,
2. Are the 2 operations completely unrelated and to be implemented separately without consideration for the other activity?
LC
December 17, 2009 at 1:38 pm
Rebuilding indexes automatically updates the stats. Reorganizing indexes does not.
There's good data on rebuilds here http://sqlserverpedia.com/blog/sql-server-bloggers/update-statistics-before-or-after-an-index-rebuild/.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 17, 2009 at 2:01 pm
Thanks, GSquared.
The link you suggested gave me the most unambigous answer I've ever received.
I am in your debt. 😀
LC
December 17, 2009 at 2:07 pm
crainlee2 (12/17/2009)
1. Does rebuilding indexes also update data distribution statistics?
Rebuilding an index updates the statistics associated with that index. It does not update any other statistics on that table. Column statistics (stats not associated with indexes) are not affected by index rebuilds.
There's a powerpoint deck on my blog that has some info on that. http://sqlinthewild.co.za/index.php/resources/ Under PASS Community Summit 2009
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 17, 2009 at 2:29 pm
Gail,
I reviewed your PowerPoint presentation. Unambiguous and to the point. Excellent. Thanks.
And I think I want to attend PASS next year.
LC
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply