-- [SQL-5-2-2-a]: x03 인덱스 생성 후 [SQL-5-2-1-a]를 재실행
CREATE INDEX tr_ord_big_x03 ON startdbpg.tr_ord_big(ord_dtm, mbr_id);
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.*
FROM startdbpg.tr_ord_big t1
WHERE t1.ord_dtm >= '2023-03-01'::date
AND t1.ord_dtm < '2023-03-03'::date
AND t1.mbr_id = 'M00031';
SQL
복사
