RSS‎ > ‎

SQL :: When to use of UPDATE_STATISTICS command?

posted Aug 22, 2012, 5:43 AM by Ashish Jain
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.