Why and when to Use UPDATE STATISTICS command
| When we have to do a large processing on data just like deletion ,updation or bulk copy so we have to update the indexes to take these changes into account so to do this UPDATE STATISTICS is used. | |
Sql Server Interview Questions