8-3-7. 조인 컬럼에 인덱스가 없다면 해시 조인

-- [SQL-8-3-7-a] EXPLAIN (ANALYZE,COSTS OFF) SELECT /*+ Leading((t2 t1)) NestLoop(t2 t1) */ t1.ord_no ,t1.item_id ,t1.ord_qty ,t2.item_cat ,t2.item_nm FROM startdbpg.tr_ord_det_big t1 INNER JOIN startdbpg.ms_item t2 ON (t2.item_id = t1.item_id) WHERE t1.ord_no BETWEEN 1 AND 3000 AND t2.item_cat = 'COF';

-- [SQL-8-3-7-b]: [SQL-8-3-7-a]에서 힌트 제거 EXPLAIN (ANALYZE,COSTS OFF) SELECT t1.ord_no ,t1.item_id ,t1.ord_qty ,t2.item_cat ,t2.item_nm FROM startdbpg.tr_ord_det_big t1 INNER JOIN startdbpg.ms_item t2 ON (t2.item_id = t1.item_id) WHERE t1.ord_no BETWEEN 1 AND 3000 AND t2.item_cat = 'COF';