Sweet Data Story
/
SQL TUNER for PostgreSQL · 기본원리편
/
학습 자료
/
Chapter 03 인덱스
/
3-1. 인덱스 개념잡기
/
3-1-2. Seq Scan
Search
3-1-2. Seq Scan
-- [SQL-3-1-2-a]
EXPLAIN
(
ANALYZE
,
COSTS
OFF
)
SELECT
t1
.
mbr_id
,
count
(
*
)
cnt
FROM
startdbpg
.
tr_ord_big t1
WHERE
t1
.
ord_dtm
>=
'2022-01-03'
::
date
AND
t1
.
ord_dtm
<
'2022-01-04'
::
date
GROUP
BY
t1
.
mbr_id
;
SQL
복사