-- [SQL-6-2-3-a]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.*
FROM startdbpg.tr_ord_big t1
WHERE t1.ord_dtm >= '2023-01-01'::date
AND t1.ord_dtm < '2023-02-01'::date
ORDER BY t1.ord_dtm;
SQL
복사
-- [SQL-6-2-3-b]: [SQL-6-2-3-a]에 LIMIT 100만 추가
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.*
FROM startdbpg.tr_ord_big t1
WHERE t1.ord_dtm >= '2023-01-01'::date
AND t1.ord_dtm < '2023-02-01'::date
ORDER BY t1.ord_dtm
LIMIT 100;
SQL
복사
-- [SQL-6-2-3-c]: [SQL-6-2-3-b]의 ORDER BY 컬럼을 ord_amt로 변경
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.*
FROM startdbpg.tr_ord_big t1
WHERE t1.ord_dtm >= '2023-01-01'::date
AND t1.ord_dtm < '2023-02-01'::date
ORDER BY t1.ord_amt
LIMIT 100;
SQL
복사
-- [SQL-6-2-3-d]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.*
FROM startdbpg.tr_ord_big t1
LIMIT 10;
SQL
복사