GRoup by YSKS option(hash group))

[spring159537]

select ysks,SUM(YPJE)*0.26 as a FROm yzlsz as a ,zlxm as b where a.ypdm=b.ypid and a.rq>='2016-08-01'and a.rq<'2016-09-01' AND
YSKS NOT IN ('骨外二区','骨外一区 ','骨外科','普外科','普外二区','普外一区','泌尿外科','五官科','口腔科','神经内科','神经内二','神经内一 ','神经外科','神经外二','神经外一','急诊一区')and B.fl3='0.26'
and a.ypdm not in ('001232','000076','000079','000075','000074','000078','000073','000099','000101','000100','000077','003783','003784','003785','003781','003782','000087','001305','001311','001390')GROUP BY YSKS option(hash group)
union all
select ysks,SUM(YPJE)*0.039 as a FROm yzlsz where rq>='2016-08-01'and rq<'2016-09-01' AND
YSKS NOT IN ('骨外二区','骨外一区 ','骨外科','普外科','普外二区','普外一区','泌尿外科','五官科','口腔科','神经内科','神经内二','神经内一 ','神经外科','神经外二','神经外一','急诊一区')and B.fl3='0.26'
and ypdm in ('001232')GROUP BY YSKS option(hash group)



查询结果显示：
消息 156，级别 15，状态 1，第 4 行
关键字 'union' 附近有语法错误。
说明：如查不使用option(hash group) 查询很慢，单条语名可以，用UNION报错。

[spring159537]

去掉option(hash group)查询很慢，得三十多分钟

[中国风]

引用 2 楼 spring159537 的回复:

去掉option(hash group)查询很慢，得三十多分钟

UNION ALL不支持加表提示 慢你看看执行计划，是不用到表扫描或索引扫描 把条件列建上索引

[中国风]

select ysks,SUM(YPJE)*0.26 as a 
FROM yzlsz as a ,zlxm as b  where a.ypdm=b.ypid and a.rq>='2016-08-01'and a.rq<'2016-09-01' AND 
YSKS NOT IN  ('骨外二区','骨外一区 ','骨外科','普外科','普外二区','普外一区','泌尿外科','五官科','口腔科','神经内科','神经内二','神经内一 ','神经外科','神经外二','神经外一','急诊一区')and B.fl3='0.26'
and a.ypdm not in ('001232','000076','000079','000075','000074','000078','000073','000099','000101','000100','000077','003783','003784','003785','003781','003782','000087','001305','001311','001390')
GROUP BY YSKS 
--OPTION(hash group)
union all 
select ysks,SUM(YPJE)*0.039 as a FROm yzlsz  where rq>='2016-08-01'and rq<'2016-09-01' AND 
YSKS NOT IN  ('骨外二区','骨外一区 ','骨外科','普外科','普外二区','普外一区','泌尿外科','五官科','口腔科','神经内科','神经内二','神经内一 ','神经外科','神经外二','神经外一','急诊一区')and B.fl3='0.26'
and ypdm in ('001232')
GROUP BY YSKS 
--OPTION(hash group)

去掉OPTION(hash group)，由数据库引擎去判断处理是否哈希