https://alidocs.dingtalk.com/i/nodes/mExel2BLV541nqKkSPKxv7kzWgk9rpMq?utm_scene=team_space
[步骤]
返回分组 数据量 13.8万。同统计366727 进行分组declare @CustomerID int=1,@StartDate datetime='2026-06-05 00:00:00',@EndDate datetime='2026-06-12'
SELECT a.CustomerID,
a.SKU,
p.ImageUrl,
p.ClientSKU,
p.ProductNameCN,
SUM(SalesNum + PendingSalesNum) SalesNum,
SUM(OrderNum + PendingNum) OrderNum,
SUM(SalesPrice + PendingSalesPrice) SalesPrice
FROM RB_Report_SKUSalesStatisticsBySite (NOLOCK) a
LEFT JOIN dbo.RB_OrderSource (nolock) s ON a.CustomerID=s.CustomerID AND a.OrderSourceID=s.ID
LEFT JOIN dbo.RB_Product (NOLOCK) p
ON p.CustomerID = a.CustomerID
AND p.SKU = a.SKU
where a.CustomerID=@CustomerID and a.SalesDay>=@StartDate and a.SalesDay
GROUP BY a.CustomerID,
a.SKU,
p.ImageUrl,
p.ClientSKU,
p.ProductNameCN
[结果]
[期望] 排查 问题，减少资源消耗
(day,1,@enddate)>