If you have a read-heavy workload, you might want to set isolation to uncommitted read (UR) at the connection level so that you don't have to specify it in each statement.
如果有一个包含大量读取操作的工作负载,那么您可能想将隔离级别设置为未提交读取(UR),从而不需要在每个语句中设置隔离级别。
Release the row locks so that other applications can SELECT, INSERT, UPDATE, and DELETE from the table (for example, use isolation level cursor stability or uncommitted read).
释放行锁,以便其他应用程序可以对表执行SELECT、INSERT、UPDATE和DELETE(例如,使用游标稳定性(curs or stability)隔离级别或未提交读(uncommitted read)隔离级别)。
For example, reading from a read - only look up table doesn t require repeatable read, and uncommitted read is sufficient.
比如,读取只读的查找表不需要可重复读级别,未提交读级别就足够了。
应用推荐