sort1 SQL 튜닝 oracle order by SORT 튜닝 [인덱스 현황] EC_COURSE_PK = course_code + year + course_sq_no EC_COURSE_IDX_01 = TEAR 튜닝전 SELECT course_code, year, course_sq_no FROM ec_course_sq WHERE course_code = 36 AND year in ('2000','1999') ORDER by course_code desc, year desc, course_sq_no desc; Elapsed: 00:00:00.09 Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=RULE 1 0 SORT (ORDER BY.. 2021. 1. 5. 이전 1 다음