Difference between "read commited" and "repeatable read"

user_482783 0
Viewed 189319

I think the above isolation levels are so alike. Could someone please describe with some nice examples what the main difference is ?

isolation-level sql-server sql
8 Answers

I think this picture can also be useful, it helps me as a reference when I want to quickly remember the differences between isolation levels (thanks to kudvenkat on youtube)

enter image description here

user_23357990

Please note that, the repeatable in repeatable read regards to a tuple, but not to the entire table. In ANSC isolation levels, phantom read anomaly can occur, which means read a table with the same where clause twice may return different return different result sets. Literally, it's not repeatable.

user_8617990
Related