-- [SQL-8-3-3-a]: [SQL-8-3-2-a]에 힌트 적용
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT /*+ Leading((t1 t2)) HashJoin(t1 t2) */
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-3-1-a]: [SQL-8-3-3-a]에서 빌드 입력인 t2의 SELECT 절 컬럼을 *로 변경
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT /*+ Leading((t1 t2)) HashJoin(t1 t2) */
t1.mbr_id ,t1.nick_nm ,t2.* -- > t2.*로 변경
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
복사