When is the use of UPDATE_STATISTICS command?

Posted by

To view Verified answers click on the button below.

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.