READ UNCOMMITTED

Learn the lowest level and dirty reads.

READ UNCOMMITTED is the lowest level. Uncommitted data can be read (dirty read).

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

Dirty reads are possible.

READ UNCOMMITTED — details

A dirty read is reading data another transaction has not committed. Fast but inconsistent.

For example, if the other transaction is rolled back, the value you read never really existed; that is why this level is rarely used in production.

Set the isolation level to READ UNCOMMITTED.

Show example solution

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

READ UNCOMMITTED

SET TRANSACTION ISOLATION LEVEL ____

Show answer

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED