Where to use UPDATE STATISTICS in SQL
| This command manily is used when we have to process large ammonut of data.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. | |