SELECT DISTINCT
a.model_serial,
a.model_name,
b.mo_number,
b.target_qty,
b.input_qty,
TO_CHAR (MIN (c.in_station_time), 'yyyy-mm-dd hh24:mi:ss') in_station_time
FROM sfis1.c_model_desc_t a
INNER JOIN sfism4.r_mo_base_t b
ON A.MODEL_NAME = B.MODEL_NAME AND A.LEVEL_GRADE = 'L6' and B.CLOSE_FLAG='3'
INNER JOIN sfism4.r_sn_detail_t c
ON B.MO_NUMBER = C.MO_NUMBER
AND c.group_name in ('SMT INPUT-B','SMT INPUT-T') --LIKE 'SMT INPUT%' --REGEXP_LIKE(C.GROUP_NAME,'SMT INPUT.')
INNER JOIN SFISM4.R_STATION_REC_T d
ON b.MO_NUMBER = D.MO_NUMBER
AND D.WORK_ID > '2014011007'
GROUP BY a.model_serial,
a.model_name,
b.mo_number,
b.target_qty,
b.input_qty
ORDER BY b.mo_number
------解决方案--------------------
http://www.jb51.net/article/30465.htm
------解决方案--------------------
toad查看执行计划:/http://blog.csdn.net/sparadise1003/article/details/3847189
先按上面的把执行计划贴出来.
你这条语句想优化, 肯定是通过加索引解决的.