Uncommitted Read

Views Updated: Dec 15, 2025

Key Facts

Abbreviation
UR
Pronunciation
/ˌənkəˈmɪtɪd rɛd/
Category
Miscellaneous
Related Field
Unclassified

Examples in Context

  1. A user will only see committed data unless the Uncommitted Read(UR) isolation level is used.
  2. Release the row locks so that other applications can SELECT, INSERT, UPDATE, and DELETE from the table ( for example, use isolation level cursor stability or uncommitted read ).
  3. For example, if one member is updating a row, it would not be proper for another member to read the row with any other isolation level than uncommitted read.
  4. If you have a read-heavy workload, you might want to set isolation to uncommitted read ( UR ) at the connection level so that you don't have to specify it in each statement.
  5. If application integrity requirements are not compromised, use Uncommitted Read(UR) instead of Cursor Stability to further decrease the amount of locking.

Other meanings of UR