Most online transaction processing (OLTP) operations, which affect only one or a few rows, use table-level modification.
if the update is relatively large, table-level modifications require a lot of random i/o operations and might read and write each leaf page in each index multiple times.