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 Level | Dirty Read | Non-repeatable Reads | Phantom Read |
---|---|---|---|
Read Uncommitted | Yes | Yes | Yes |
Read Committed | No | Yes | Yes |
Repeatable Read | No | No | Yes |
Serializable | No | No | No |