Transaction Isolation Levels (cont)
Implication of transaction isolation levels:
Isolation Level |
Dirty Read |
Nonrepeatable Read |
Phantom Read |
Read Uncommitted |
Possible |
Possible |
Possible |
Read Committed |
Not Possible |
Possible |
Possible |
Repeatable Read |
Not Possible |
Not Possible |
Possible |
Serializable |
Not Possible |
Not Possible |
Not Possible |
|