When is the use of UPDATE_STATISTICS command?

 Posted by Blessybaby on 1/6/2010 | Category: Sql Server Interview questions | Views: 4672

This command is basically used when a large processing of data has occurred. If a large amount of deletions any modification or Bulk Copy into the tables has occurred, it has to update the indexes to take these changes into account. UPDATE_STATISTICS updates the indexes on these tables accordingly.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response