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.
 
Thanx.
Vinay
 
 
 
 
Advertisements
This entry was posted in What I learned today and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s