Chapter 34: Using Statistics to Improve Performance
Locking, scans and sorts during update
The update all statistics commands generates
a series of update statistics operations for
each index on the table, followed by a series of update
statistics operations for all unindexed columns, followed
by an update partition statistics operation.