안녕하세요
속도가 느립니다. 인덱스를 어떤방법으로 설정해야 하는지 또는 속도개선방법이 있는지 궁금합니다.
*table 설명
pang1 출근 table 70만것
pan51 기초 table
*결과내용
1 1 2 3983 183 10
1 2 2 6085 382 18
1 3 2 2144 137 9
1 4 2 0 0 0
1 5 2 1181 82 4
1 6 2 3823 164 15
*쿼리내용입니다.
Select 1 as b_Line,
K_Com3 as b_Name,
2 as b_Bigo,
a_wLnT as b_wLnT,
a_jLnT as b_jLnT,
a_dLnT as b_dLnT
From pan51 a
Left Outer Join
(Select K_Com3 as J_Com3,
Sum(If(J_Date <'2009.10.01',J_inwo,0)) as a_wLnt,
Sum(If(J_Date>='2009.10.01' And
J_Date< '2009.10.26',J_inwo,0)) as a_jLnt,
Sum(If(J_Date ='2009.10.26',J_inwo,0)) as a_dLnt
From pang1 b
Left Join pan51 c on c.K_Code=0010
and c.K_Bulu=b.J_JjCd
Where J_Upja ='00045'
Group By J_Com3) b1 On a.K_Com3=b1.J_Com3
Where K_Bigo<>''
and K_Code=0010
and (K_Com3= 1
Or K_Com3= 2
Or K_Com3= 3
Or K_Com3= 4
Or K_Com3= 5
Or K_Com3= 6
Or K_Com3=15)
Group By B_Line,b_Name,b_Bigo
union all
Select 2 as b_Line,
D_Name as b_Name,
K_Bigo as b_Bigo,
a_wLnT as b_wLnT,
a_jLnT as b_jLnT,
a_dLnT as b_dLnT
From pan71 x
Left Join pan51 y on y.K_Code=0010
and y.K_Bulu=x.D_JjCd
Left Outer Join
(Select K_Bigo as J_Com3,
Sum(If(J_Date <'2009.10.01',J_inwo,0)) as a_wLnt,
Sum(If(J_Date>='2009.10.01' And
J_Date< '2009.10.26',J_inwo,0)) as a_jLnt,
Sum(If(J_Date ='2009.10.26',J_inwo,0)) as a_dLnt
From pang1 b
Left Join pan51 c on c.K_Code=0010
and c.K_Bulu=b.J_JjCd
Where J_Upja ='00045'
and K_Com3 =7
Group By J_Com3) x1 On y.K_Bigo=x1.J_Com3
Where x.D_Upja ='00045'
and y.K_Chek ='형틀'
and y.K_Com2 ='팀장'
Group By b_Line,b_Name,b_Bigo
|