안녕하세요.
현재 쿼리를 실행하면 8초정도가 나오는데
쿼리수정으로 시간을 더 줄일수있을까요?
se_as_code테이블은 코드테이블이고
se_program_manage는 180만건 정도있는 데이터 테이블입니다.
SELECT AGROUP FROM (SELECT AGROUP FROM (SELECT CO.ACODE AGROUP FROM (SELECT ACODE, ANAME, APRCODE FROM se_as_code WHERE USEYN = 'Y' AND CLCODE = 'AS' AND ALVL = '1') CO LEFT OUTER JOIN se_program_manage PM ON CO.ACODE = PM.ASSOCIATION AND PM.SDATE >= '2021-10-01' WHERE 1 = 1 GROUP BY CO.ACODE ORDER BY CO.ACODE ASC) A GROUP BY AGROUP ORDER BY AGROUP) B