문서의 이전 판입니다!
SELECT /*+ USE_NL(a b c) */... FROM TAB1 a, TAB2 b, TAB3 c WHERE ...
예) SELECT /*+ NO_USE_NL(l h) */....... FROM orders h, order_items l WHERE l.order_id, = h.order_id AND l.order_date >= '20050101';
예) SELECT /*+ USE_NL_WITH_INDEX(l item_prod_ix) */.... FROM orders hm order_items l WHERE l.order_id = h.order_id AND l.order_item like 'ADEN%' AND h.order_dt between '20051001' and '20051015';
예) SELECT /*+ USE_HASH (a b) */... FROM sale a, pre_order b WHERE a.order_id = b.order_id AND a.sale_dt LIKE '2005%';
예) SELECT /*+ NO_USE_HASH(m d) */.... FROM member m, dept d WHERE m.deptid = d.deptid;
예) SELECT /*+ USE_MERGE(a b) */....... FROM sale a, pre_order b WHERE a.order_id = b.order_id AND a.sale_dt BETWEEN '20050701' AND '20050930' AND b.cust_no = '101';