What is the use of UPDATE_STATISTICS command ?

 Posted by Bharathi Cherukuri on 3/17/2012 | Category: Sql Server Interview questions | Views: 3879 | Points: 40

UPDATE_STATISTICS updates the indexes on the tables accordingly.
If there occurs any large amount of modifications such as, large amount of deletions,modifications or Bulk copy into the tables has occurred,then this command has to update the indexes to take these changes into account.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response