7-2-2. 머지 조인의 실행계획

-- [SQL-7-2-2-a] EXPLAIN (ANALYZE,COSTS OFF) SELECT /*+ Leading((t1 t2)) MergeJoin(t1 t2) */ * FROM startdbpg.ms_mbr t1 INNER JOIN startdbpg.tr_ord t2 ON (t1.mbr_id = t2.mbr_id) WHERE t1.mbr_gd = 'PLAT' AND t1.join_dtm = '2019-03-24'::date AND t2.ord_dtm >= '2019-04-01'::date AND t2.ord_dtm < '2019-04-10'::date;