Search

4-4-1. Index Full Scan

-- [SQL-4-4-1-a] EXPLAIN (ANALYZE,BUFFERS,COSTS OFF) SELECT t1.ord_dtm FROM startdbpg.tr_ord_big t1 WHERE TO_CHAR(t1.ord_dtm,'YYYY-MM-DD') >= '2023-03-01' AND TO_CHAR(t1.ord_dtm,'YYYY-MM-DD') < '2023-03-03';
SQL
복사