When does the UPDATE_STATISTICS command used?

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.