Sweet Data Story
/
SQL TUNER for PostgreSQL · 기본원리편
/
학습 자료
/
Chapter 04 PostgreSQL의 인덱스 스캔
/
4-3. Bitmap Scan
/
4-3-1. Bitmap Index Scan & Bitmap Heap Scan
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
복사