SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Reindex and Update stats.

Today I was reading blog by Ben Nevarez it is great... (I am impressed with ben now a days) that's why Kalen always ask him for reviewing his book (all INSIDE books reviewed by Ben.)
update statistics and rebuild index: the rebuild index will rebuild the index statistics as well and
update statistics with FULL_SCAN will update the statistics of index(with default value) and column.
so when you run this two maintenance job we may be redoing the things twice.
so here we can make things like.
schedule rebuild index (alter index rebuild) and then update_statistics with FULL_Scan,columns.
*index Reorganization (defrag) will not create any statistics.
also updatestats will update the missing stats only.


No comments.

Leave a Comment

Please register or log in to leave a comment.