Mark As Completed Discussion

Summary

Different isolation levels exist, and you can choose to use any one of them depending on your preferences regarding your database. A summary of isolation levels with the read phenomena they tackle is given below.

Isolation LevelDirty ReadNon-repeatable ReadsPhantom Read
Read UncommittedYesYesYes
Read CommittedNoYesYes
Repeatable ReadNoNoYes
SerializableNoNoNo