안녕하세요 mysql질문 입니다.

밑에 쿼리인데 너무 느려서요..

select
date_format(A.send_date, '%Y-%m-%d')  as sendDate,
Sum(case when  A.RESERVED1='1' then 1 else 0 END)  as pay,
Sum(case when  A.RESERVED1='0' then 1 else 0 END)  as free,
Sum(case when  A.RESERVED1='2' then 1 else 0 END)  as yearpay,
Sum(case when  A.RESERVED1='3' then 1 else 0 END)  as know,
Sum(case when A.RESERVED1 in ('4','6') then 1 else 0 END) as become,
sum(case when A.RESERVED1 in ('0','1','2','3','4','6') then 1 else 0 end) as sumhap,
sum(case when A.RESERVED1='1' then 20 else 12 end) as chargeGubun
from(

) sdk_sms_report as A
inner join (select distinct B.PHONE_NUMBER, B.SEND_DATE, B.User_Id, B.Job_ID, C.User_UserID, C.Expert_ExpertIdx, C.Partner_SiteId
     from sdk_sms_report_detail B
     inner join subscribe C on (B.PHONE_NUMBER = C.User_UserID) and (B.User_Id = C.Expert_ExpertIdx)
     where  B.User_Id is not Null) as D on (D.Job_ID = A.Job_ID)
WHERE  A.RESERVED1 IS NOT NULL
GROUP BY sendDate

결과값은

위결과가 결과값입니다.

SMS 발생통계인데..

subscribe 테이블에는 8934 데이타 수가 있고

sdk_sms_report 테이블에는 2724 데이타 수가 있고

sdk_sms_report_detail  테이블에는 178188 데이터 수가 있습니다.

이걸 좀 빠르게 할수 있나요