执行select查询秒出结果,执行update半天都出不来直到超时,求大神帮忙!!!
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
safety_activateLog:131055条
safety_code:1425744条
safety_activateLog where BatchCode='1445268400'
1083条
safety_code where lsstate=1
1165271条
表锁无: