1.原sql
| SQL | 执行次数 | 平均I_O | 总I_O | 逻辑写 | 逻辑读 | CPU平均耗时 | 总CPU耗时_秒 | 优化建议 |
| (@CustomerID int)SELECT DISTINCT a.ID AS FeeID, a.Currency, a.AreaID, b.AreaName, b.AreaType, Isnull(c.SupplierCode, c.SupplierName) AS SupplierCode, d.TransportName, d.TransferAttribute, e.CustomerID, e.RegisteredFee, e.HandleFee, e.Discount, Isnull(ac.CountryID, 0) CountryID, ac.ProvincesCN, e.TransportDaysFrom, e.TransportDaysTo, e.Memo, a.ShipFeeType, d.ID TransportID, Isnull(c.IsActive, 0) AS IsActiveWithTransportSupplier FROM RB_Transport_Fee a WITH ( NOLOCK ) INNER JOIN RB_Area AS b(nolock) ON a.AreaID = b.ID LEFT JOIN RB_Area_Country ac(NOLOCK) ON a.AreaID = ac.AreaID AND a.CustomerID = ac.CustomerID LEFT JOIN RB_Transport_Supplier AS c(nolock) ON a.SupplierID = c.ID LEFT JOIN RB_Transport AS d(nolock) ON a.TransportID = d.ID AND a.SupplierID = d.DefaultSupplierID LEFT JOIN RB_Transport_SupplierTransport AS e(nolock) ON a.SupplierID = e.TransprotSupplierID AND a.TransportID = e.TransportID WHERE a.CustomerID = @CustomerID ORDER BY FeeID DESC | 122 | 102070 | 12452552 | 30864 | 12421688 | 1044 | 127427 | 建议加入缓存 |
2.Erp系统对应位置
3.代码最后提交记录
