Sweet Data Story
/
SQL TUNER for PostgreSQL · 기본원리편
/
학습 자료
/
Chapter 06 정렬과 집계
/
6-2. 정렬과 인덱스
/
6-2-1. No Sort
Search
6-2-1. No Sort
-- [SQL-6-2-1-a]
EXPLAIN
(
ANALYZE
,
BUFFERS
,
COSTS
OFF
)
SELECT
t1
.
*
FROM
startdbpg
.
tr_ord_big t1
WHERE
t1
.
ord_dtm
>=
'2023-01-01'
::
date
AND
t1
.
ord_dtm
<
'2023-02-01'
::
date
ORDER
BY
t1
.
ord_dtm
;
SQL
복사