7-1-4. NL 조인의 실행계획

-- [SQL-7-1-4-a] EXPLAIN (ANALYZE,COSTS OFF) SELECT /*+ Leading((t1 t2)) NestLoop(t1 t2) IndexScan(t2 tr_ord_fk01) */ * 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;