Answer:
UPDATE_STATISTICS updates the indexes on the tables accordingly.
If there occurs any large amount of modifications such as, large amount of deletions,modifications or Bulk copy into the tables has occurred,then this command has to update the indexes to take these changes into account.
Asked In: Many Interviews |
Alert Moderator