Locking, scans, and sorts during update index statistics

The update index statistics command generates a series of update statistics operations that use the same locking, scanning, and sorting as the equivalent index-level and column-level command. For example, if the salesdetail table has a nonclustered index named sales_det_ix on salesdetail(stor_id, ord_num, title_id), this command:

update index statistics salesdetail

performs these update statistics operations:

update statistics salesdetail sales_det_ix 
update statistics salesdetail (ord_num)
update statistics salesdetail (title_id)