What is a transaction isolation level?medium

Type
conceptual
Topic
transaction-isolation-level
Frequency
common
Tags
transaction, isolation, level
Answer

It controls how much concurrent transactions can see or affect each other.

Explanation

Isolation levels trade consistency for performance and can prevent anomalies such as dirty reads, non-repeatable reads, and phantom reads.

Follow-upWhat is the difference between repeatable read and serializable?