1.原sql
| SQL | 执行次数 | 平均I_O | 总I_O | 逻辑写 | 逻辑读 | CPU平均耗时 | 总CPU耗时_秒 | 优化建议 |
| (@CustomerID int,@OrderSourceSKU varchar(max) ,@OrderSourceID varchar(max) ,@SKU varchar(max) )SELECT ID, CustomerID, OrderSourceSKUID, OrderSourceID, OrderSourceSKU, SKU, msaleNum, todaysaleNum, ThreeMonthSaleNum, zsaleNum, qsaleNum, sqsaleNum, WeekSaleNum, TwoWeekSaleNum, lastmsaleNum, FirstLegShippingType FROM dbo.RB_Amazon_Product_Base(NOLOCK) WHERE CustomerID = @CustomerID AND OrderSourceSKU IN ( SELECT item FROM CharSplitForIn(@OrderSourceSKU, ',') ) AND OrderSourceID IN ( SELECT item FROM CharSplitForIn(@OrderSourceID, ',') ) AND SKU IN ( SELECT item FROM CharSplitForIn(@SKU, ',') ) AND OrderSourceSKUID > 0 AND IsOffShelf = 0; | 627 | 1795 | 1125524 | 913 | 1124611 | 57 | 36184 | 过多的CharSplitForIn，建议慎重判断数量适当用IN明确值的模式 |
2.Erp系统对应位置
3.代码最后提交记录
