34,590
社区成员
发帖
与我相关
我的任务
分享
update statistics JC_YGRZM
update statistics JC_YGRZD
如果还是不快,那么可以考虑加上查询提示option:
SELECT ygbh,
Sum(CASE
WHEN je < 0 THEN 0
ELSE je
END) AS je
FROM ((SELECT v2.ygbh,
Round(( ( v1.fjbyyd - v1.fjsyyd ) / v1.zts * v2.sjts - v2.kyds )
*
v2.yfdj, 0)
AS JE
FROM jc_ygrzm v1
INNER JOIN jc_ygrzd v2
ON v1.ssbh = V2.ssbh
AND v1.jzdh = v2.jzdh
WHERE v1.jzdh = 'JZ0028')) AS df
GROUP BY ygbh
option(hash group) --添加这行,如果还是不快改为: option(order group)