13. Understanding the Locking System : User-Controlled Locking--SET LOCKMODE : Isolation Levels : Read Uncommitted Isolation Level
 
Share this page                  
Read Uncommitted Isolation Level
The Read Uncommitted (RU) isolation level provides greatly increased read and write concurrency, but “dirty reads” may occur. RU is ideal for applications where the reading of uncommitted data is not a concern. Greater concurrency is achieved because the RU transaction does not acquire locks on data being read and other transactions can immediately read or modify the same rows.