When does the UPDATE_STATISTICS command used?

 Posted by vishalneeraj-24503 on 10/7/2014 | Category: Sql Server Interview questions | Views: 499 | Points: 40
Answer:

1). When the processing of large data is done,UPDATE_STATISTICS command is used.
2). Whenever large number of deletions,modification or copy takes place into the tables,the indexes need to be updated to take care of these changes.UPDATE_STATISTICS performs this job.
3). It updates query optimization statistics on a table or indexed view.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response