[性能问题描述]
(@CustomerID0 int,@OrderSourceID1 int,@TransactionType2 nvarchar(4000),@TransactionStatus3 nvarchar(4000))SELECT [ID] AS [Id] , [CustomerID] AS [CustomerID] , [OrderSourceID] AS [OrderSourceID] , [AmazonOrderId] AS [AmazonOrderId] , [TransactionId] AS [TransactionId] , [DeferredId] AS [DeferredId] , [PostedDate] AS [PostedDate] , [IsMultiDeferred] AS [IsMultiDeferred] FROM [RB_Amazon_Listtransactions_Pivot] WHERE ( [CustomerID] = @CustomerID0 ) AND ( [OrderSourceID] = @OrderSourceID1 ) AND ((( [TransactionType] = @TransactionType2 ) AND ( [TransactionStatus] = @TransactionStatus3 )) AND NOT ( [IsFullyReleased]=1 ) )
[分析过程]
该SQL 语句 未添加 nolock ，查询 速度慢 造成大量阻塞
[期望结果]
补充 nolock