如何优化查询,提高速度
买买提子 2015-11-03 09:55:43 SELECT ywy,sl AS '数量',yhrq,MONTH(yhrq) AS '月份',CONCAT(spdm,spmc,scgg,bzgg) AS dmmc FROM
(SELECT
ywy,
yhrq,
bb.yhbh
pk_corp,
sl,
spdm,
spmc,
scgg,
bzgg
FROM
(SELECT
ywy,
yhrq,
yhbh,
pk_corp,
sl,
spdm,
spmc,
scgg,
bzgg
FROM
cr_demandplan
WHERE RecDR = 0)bb
INNER JOIN
(SELECT
yhbh,
pk_corp
FROM
cr_demandplan
WHERE RecAs3 = '通过'
GROUP BY CONCAT(yhbh,pk_corp))aa
ON CONCAT(bb.yhbh, bb.pk_corp) = CONCAT(aa.yhbh, aa.pk_corp))cc
WHERE ywy ='小明' AND CONCAT(spdm,spmc,scgg,bzgg) = '0000000047胶囊0.5g30粒/300盒' AND yhrq BETWEEN '2014-01-01' AND '2014-12-31'