Search

4-3-1. Bitmap Index Scan & Bitmap Heap Scan

-- [SQL-4-3-1-a] EXPLAIN (ANALYZE,COSTS OFF) SELECT /*+ BitmapScan(t1) */ 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
복사