INSERT INTO us_info (seq, C_type, M_type, C_AMT, AMT, MIN, MAX)
SELECT seq, C_type, M_type, C_AMT, AMT, MIN, MAX FROM
(SELECT B.seq AS seq, A.C_type, A.M_type, SUM(A.C_AMT), SUM(A.AMT) AS KRW_AMT, MIN(A.MIN), MAX(A.MAX)
FROM us_exchange A FORCE INDEX(INDEX) RIGHT JOIN m_sub B
ON A.C_type= B.seq
WHERE A.DT > DATE_ADD(NOW(3), INTERVAL -24 HOUR) AND A.C_type= "ABC" AND A.M_type= "DEF") AS C;
ON DUPLICATE KEY UPDATE idx = C.seq;
해당 쿼리를 돌렸을때 SELECT 문만 돌렸을시 쿼리타임이 0.078 나오는데 INSERT 타임은 2.8초가 나옵니다 혹시 어떤점을 수정해야될지 조언 부탁드립니다!!