1.原sql
| SQL | 执行次数 | 平均I_O | 总I_O | 逻辑写 | 逻辑读 | CPU平均耗时 | 总CPU耗时_秒 | 优化建议 |
| (@CustomerID int,@OrderSourceID int)select [ID],[CustomerID],[OrderSourceSKUID],[OrderSourceID],[OrderSourceSKU],[SKU],[TodaySales],[YesterdaySales],[BeforeYesterdaySales],[PreviousDaySales],[WeekSales],[TwoWeekSales],[ThirtyDaySales],[NinetyDaySales],[LastMonthSales],[AddTime],[UpdateTime] from [RB_Amazon_Product_Base_Sales] (nolock) where CustomerID = @CustomerID AND OrderSourceID = @OrderSourceID; | 792 | 325 | 257448 | 0 | 257448 | 1 | 913 | 返回数据多,建议按照一定量(1000)分页处理 |
2.Erp系统对应位置

3.代码最后提交记录
