001- 性能优化-库存分配单 相关SQL 查询缓慢
001+ 【性能优化】库存分配单SQL的OR改UNION

001- 性能优化-库存分配单 相关SQL 查询缓慢
001+ 【性能优化】库存分配单SQL的OR改UNION

001- [步骤]
001+ <a href="https://alidocs.dingtalk.com/i/nodes/YQBnd5ExVEwXEnODu6RAegow8yeZqMmz">https://alidocs.dingtalk.com/i/nodes/YQBnd5ExVEwXEnODu6RAegow8yeZqMmz
002- SELECT               oi.OrderSourceID,os.OrderSourceName,               ad.ID AllocationBillID,               ad.AllocationNumber,               ad.RelationId AS PackageID,               ad.OrginNumber AS OrderCode,               ISNULL(op.TrackNumber,'')TrackNumber,               oi.AmazonShipmentId              FROM               RB_Inventory_AllocationBill ad(NOLOCK)               LEFT JOIN RB_OrderInfo oi(NOLOCK) ON oi.OrderCode = ad.OrginNumber AND ad.CustomerID = oi.CustomerID               LEFT JOIN RB_Procurement_Order_Package op(NOLOCK) ON ad.RelationId = op.ID               JOIN RB_OrderSource os(NOLOCK) ON os.ID = oi.OrderSourceId AND os.CustomerID = oi.CustomerID              WHERE              ad.CustomerID =1 AND oi.IsStockOrder=1 AND (   ad.RelationId in( 72647879 ) OR   op.TrackNumber in( select item FROM CharSplitForIn('D72647879', ','))  OR oi.OrderCode in(select item FROM CharSplitForIn('D72647879', ',') ) ) [结果]
002+ [步骤]
003- [期望]
003+ SELECT oi.OrderSourceID,os.OrderSourceName, ad.ID AllocationBillID, ad.AllocationNumber, ad.RelationId AS PackageID, ad.OrginNumber AS OrderCode, ISNULL(op.TrackNumber,'')TrackNumber, oi.AmazonShipmentId FROM RB_Inventory_AllocationBill ad(NOLOCK) LEFT JOIN RB_OrderInfo oi(NOLOCK) ON oi.OrderCode = ad.OrginNumber AND ad.CustomerID = oi.CustomerID LEFT JOIN RB_Procurement_Order_Package op(NOLOCK) ON ad.RelationId = op.ID JOIN RB_OrderSource os(NOLOCK) ON os.ID = oi.OrderSourceId AND os.CustomerID = oi.CustomerID WHERE ad.CustomerID =1 AND oi.IsStockOrder=1 AND ( ad.RelationId in( 72647879 ) OR op.TrackNumber in( select item FROM CharSplitForIn('D72647879', ',')) OR oi.OrderCode in(select item FROM CharSplitForIn('D72647879', ',') ) ) [结果]
004- 把 or 拆分成 union 操作拼接 成多条语句
004+ [期望]
005-
005+ 把 or 拆分成 union 操作拼接 成多条语句
006+

001- <p>[步骤]</p>
001+ <p><a href="https://alidocs.dingtalk.com/i/nodes/YQBnd5ExVEwXEnODu6RAegow8yeZqMmz">https://alidocs.dingtalk.com/i/nodes/YQBnd5ExVEwXEnODu6RAegow8yeZqMmz</a></p>
002- SELECT               oi.OrderSourceID,os.OrderSourceName,               ad.ID AllocationBillID,               ad.AllocationNumber,               ad.RelationId AS PackageID,               ad.OrginNumber AS OrderCode,               ISNULL(op.TrackNumber,'')TrackNumber,               oi.AmazonShipmentId              FROM               RB_Inventory_AllocationBill ad(NOLOCK)               LEFT JOIN RB_OrderInfo oi(NOLOCK) ON oi.OrderCode = ad.OrginNumber AND ad.CustomerID = oi.CustomerID               LEFT JOIN RB_Procurement_Order_Package op(NOLOCK) ON ad.RelationId = op.ID               JOIN RB_OrderSource os(NOLOCK) ON os.ID = oi.OrderSourceId AND os.CustomerID = oi.CustomerID              WHERE              ad.CustomerID =1 AND oi.IsStockOrder=1 AND (   ad.RelationId in( 72647879 ) OR   op.TrackNumber in( select item FROM CharSplitForIn('D72647879', ','))  OR oi.OrderCode in(select item FROM CharSplitForIn('D72647879', ',') ) ) <br /><p>[结果]</p>
002+ <p>[步骤]</p>
003- <br /><p>[期望]</p>
003+ SELECT oi.OrderSourceID,os.OrderSourceName, ad.ID AllocationBillID, ad.AllocationNumber, ad.RelationId AS PackageID, ad.OrginNumber AS OrderCode, ISNULL(op.TrackNumber,'')TrackNumber, oi.AmazonShipmentId FROM RB_Inventory_AllocationBill ad(NOLOCK) LEFT JOIN RB_OrderInfo oi(NOLOCK) ON oi.OrderCode = ad.OrginNumber AND ad.CustomerID = oi.CustomerID LEFT JOIN RB_Procurement_Order_Package op(NOLOCK) ON ad.RelationId = op.ID JOIN RB_OrderSource os(NOLOCK) ON os.ID = oi.OrderSourceId AND os.CustomerID = oi.CustomerID WHERE ad.CustomerID =1 AND oi.IsStockOrder=1 AND ( ad.RelationId in( 72647879 ) OR op.TrackNumber in( select item FROM CharSplitForIn('D72647879', ',')) OR oi.OrderCode in(select item FROM CharSplitForIn('D72647879', ',') ) ) <br /><p>[结果]</p>
004- <p>把 or 拆分成 union 操作拼接 成多条语句</p>
004+ <br /><p>[期望]</p>
005- <br />
005+ <p>把 or 拆分成 union 操作拼接 成多条语句</p>
006+ <br />