关于执行效率
SELECT pack_pdt, rackno, picno
FROM exp_outplan
WHERE pack_pdt >= '20040110'
AND pack_pdt <= '20050117'
AND bs_type = 1
AND allocstate_fg = 1
AND ip_fg = 0
GROUP BY pack_pdt, rackno, picno
ORDER BY rackno
执行十分的慢(65秒左右,才24万数据),分析了一下,主要是
pack_pdt >= '20040110'
AND pack_pdt <= '20050117'
慢,索引已经有了
各位高手看看有什么办法提高速度