[步骤]
SELECT t.ID, t.TransportName
FROM RB_Transport t WITH (NOLOCK)
LEFT JOIN RB_PlatformTransport prt WITH (NOLOCK)
ON t.CustomerID = prt.CustomerID
AND t.id = prt.TransportID
WHERE t.CustomerID = @CustomerID
AND t.IsActive = ?
AND prt.OrderSourceType = @OrderSourceType
AND t.WareHouseIDs LIKE ?
1、表[irobotbox].[dbo].[RB_Transport]在字段WareHouseIDs上使用了函数like,导致Non-SARG查询[irobotbox].[dbo].[RB_Transport].[WareHouseIDs] as [t].[WareHouseIDs] like '%,5312,%',从而无法使用IndexSeek，请改写查询。
[结果]
[期望]
请整改优化，降低资源消耗
