SQL isolation levels and multiple granularity locking
The four standard SQL isolation levels and the specific anomalies each one allows, plus intention locks for efficiently locking at the table, page, or row level.
9 min readUpdated 2026-09-04dbmsisolation-levelsmultiple-granularity-locking