When is the use of UPDATE_STATISTICS command?
Written by Agetinfence Monday, 09 January 2012 17:33
This command is basically used when a large amount of data is processed. If a large amount of deletions, modifications 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.
| < Prev | Next > |
|---|