存储过程执行超慢 求语句 谢谢

[majianmei757]

CREATE PROCEDURE yckgx AS
update qyddk2
set fhsl=0
where fhsl<>0
begin

update qyddk2
set xssl=b.ik5
from (
select ddh,xh,gg,hw,sh,gd,dw,kh,sum(ik5) ik5
from
(
select ddh,xh,gg,hw,sh,gd,dw,kh,ik5 from qycksj
union all
select ddh,xh,gg,hw,sh,gd,dw,kh,ik5 from ipss
union all select ddh,xh,gg,hw,sh,gd,dw,kh,0 ik5 from qyddk2
)a
group by ddh,xh,gg,hw,sh,gd,dw,kh
) b
where qyddk2.ddh=b.ddh and qyddk2.xh=b.xh and qyddk2.gg=b.gg and qyddk2.hw=b.hw and qyddk2.sh=b.sh and qyddk2.gd=b.gd and qyddk2.dw=b.dw and qyddk2.kh=b.kh
end
GO

[ReViSion]

好多层，晕

[chinaandys]

-------------------------------这一块为什么不用Join了
select ddh,xh,gg,hw,sh,gd,dw,kh,sum(ik5) ik5
from
(
select ddh,xh,gg,hw,sh,gd,dw,kh,ik5 from qycksj
union all
select ddh,xh,gg,hw,sh,gd,dw,kh,ik5 from ipss
union all select ddh,xh,gg,hw,sh,gd,dw,kh,0 ik5 from qyddk2
)a
group by ddh,xh,gg,hw,sh,gd,dw,kh
) b