Search

6-2-7. ORDER BY를 빼먹지 말자.

-- [SQL-6-2-7-a] SELECT /*+ IndexScan(t1 tr_ord_big_x01) */ t1.* FROM startdbpg.tr_ord_big t1 WHERE t1.ord_dtm >= '2024-04-01'::date AND t1.ord_dtm < '2024-05-01'::date;
SQL
복사