Transactions

Row-Level Locking

English

Overview

A locking method that locks only the rows being updated, rather than the whole table.

Details

Because the lock granularity is finer than table-level locking, it allows for higher concurrency. Most relational databases adopt it as their default locking level.

More Database terms