You have a transaction that uses the repeatable read isolation level. This transaction causes frequent blocking problems.
You need to reduce blocking. You also need to avoid dirty reads and non-repeatable reads.
Which transaction isolation level should you use?
A. SNAPSHOT
B. SERIALIZABLE
C. READ UNCOMMITTED
D. READ COMMITTED