You need to resolve the blocking issue that is affecting the performance of the CRM system. What should you do?（）

A.Replace the named query with an SQL view.

B.Set the transaction isolation level to serializable in the named query.

C.Set the source database to use snapshot isolation.

D.Set the transaction isolation level to repeatable read in the named query.