[性能问题描述]

(@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