-- [SQL-8-3-2-a]
SELECT t1.mbr_id ,t1.nick_nm ,t2.ord_dtm ,t2.ord_amt
FROM startdbpg.ms_mbr_big t1
INNER JOIN startdbpg.tr_ord_big t2
ON (t1.mbr_id = t2.mbr_id)
WHERE t1.mbr_gd = 'PLAT'
AND t2.prep_cmp_dtm >= '2023-01-01'::date
AND t2.prep_cmp_dtm < '2023-04-01'::date;
SQL
복사
-- [SQL-8-3-2-b]: x26 인덱스 생성 후 [SQL-8-3-2-a]를 재실행
CREATE INDEX tr_ord_big_x26 ON startdbpg.tr_ord_big(prep_cmp_dtm);
-- [SQL-8-3-2-a]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.mbr_id ,t1.nick_nm ,t2.ord_dtm ,t2.ord_amt
FROM startdbpg.ms_mbr_big t1
INNER JOIN startdbpg.tr_ord_big t2
ON (t1.mbr_id = t2.mbr_id)
WHERE t1.mbr_gd = 'PLAT'
AND t2.prep_cmp_dtm >= '2023-01-01'::date
AND t2.prep_cmp_dtm < '2023-04-01'::date;
SQL
복사