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