-- [SQL-4-2-2-a]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.ord_dtm
FROM startdbpg.tr_ord_big t1
WHERE t1.ord_dtm >= '2023-03-01'::date
AND t1.ord_dtm < '2023-03-03'::date;
SQL
복사
-- [SQL-4-2-2-b]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.ord_dtm ,t1.ord_no
FROM startdbpg.tr_ord_big t1
WHERE t1.ord_dtm >= '2023-03-01'::date
AND t1.ord_dtm < '2023-03-03'::date;
SQL
복사

