-- [SQL-6-2-6-a]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.*
FROM startdbpg.tr_ord_big t1
WHERE t1.ord_dtm >= '2024-04-01'::date
AND t1.ord_dtm < '2024-05-01'::date
ORDER BY t1.ord_dtm DESC ,t1.ord_amt DESC
LIMIT 30;
SQL
복사
-- [SQL-6-2-6-b]: incremental sort 기능을 비활성화한 후에 [SQL-6-2-6-a]를 재실행
SET enable_incremental_sort = OFF;
-- [SQL-6-2-6-a]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.*
FROM startdbpg.tr_ord_big t1
WHERE t1.ord_dtm >= '2024-04-01'::date
AND t1.ord_dtm < '2024-05-01'::date
ORDER BY t1.ord_dtm DESC ,t1.ord_amt DESC
LIMIT 30;
SQL
복사
-- [SQL-6-2-6-c]
SET enable_incremental_sort = ON;
SQL
복사