SELECT a.mast_id
, a.mast_nm
, a.mast_idt
, a.mast_odt
, a.mast_part_cd
, b.cdma_value4
, a.mast_regi_cd
, c.cdma_value1
, a.mast_jumin
, d.reco_value1
, d.reco_value2
, d.reco_value3
, d.reco_value4
, d.reco_value5
, d.reco_value9
, e.reco_value1
, e.reco_value2
, f.cdma_value4
, e.reco_value3
, g.cdma_value1
, e.reco_value4
, e.reco_value5
, e.reco_value9
FROM ydh.tb_insa_master a
LEFT OUTER JOIN ydh.tb_insa_cdmaster b ON b.cdma_host_id = a.mast_host_id AND b.cdma_class = 'PART' AND b.cdma_cd = a.mast_part_cd
LEFT OUTER JOIN ydh.tb_insa_cdmaster c ON c.cdma_host_id = a.mast_host_id AND c.cdma_class = 'REGI' AND c.cdma_cd = a.mast_regi_cd
LEFT OUTER JOIN ydh.tb_insa_record d ON d.reco_host_id = a.mast_host_id AND d.reco_gbn = 'S_TMNY' AND d.reco_mast_id = a.mast_id AND d.reco_seq = '2012'
LEFT OUTER JOIN ydh.tb_insa_record e ON e.reco_host_id = a.mast_host_id AND e.reco_gbn = 'S_TMNY' AND e.reco_mast_id = a.mast_id AND e.reco_seq = '2013'
LEFT OUTER JOIN ydh.tb_insa_cdmaster f ON f.cdma_host_id = a.mast_host_id AND f.cdma_class = 'PART' AND f.cdma_cd = e.reco_value2
LEFT OUTER JOIN ydh.tb_insa_cdmaster g ON g.cdma_host_id = a.mast_host_id AND g.cdma_class = 'REGI' AND g.cdma_cd = e.reco_value3
WHERE a.mast_host_id = '100001'
AND (a.mast_odt IS NULL OR a.mast_odt >= '20130101')
ORDER BY a.mast_part_cd, c.cdma_value2, a.mast_jumin
a.mast_host_id는 '100001'입니다.
LEFT OUTER JOIN에서 b.~ g.cdma_host_id = a.mast_host_id 대신
g.cdma_host_id = '100001'로 해서 실행하면 속도가 엄청느려집니다.
왜 그런걸까요?
|