Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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.
 
Thanx.
Vinay
 
 
 
 

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.