title: Oracle join using Hint USE_NL USE_HASH
body: <p>What is the best way to Force execution plan to do only nested loop joins for all tables using Hint USE_NL in once case,<br>
  And in other case to do only Hash Join using USE_HASH hint for all tables
  I want to run both query and see which has low cost in execution plan and use, please suggest  </p>
  
  <p>My doubt is in which sequence i should put for all 4 tables inside HINT like below 
  USE_NL(bl1_gain_adj,customers,bl1_gain,bl1_reply_code) </p>
  
  <pre><code>SELECT bl1_gain_adj.adj_seq_no,
  bl1_gain_adj.amount_currency ,
  bl1_gain_adj.gain_seq_no, 
  customers.loan_key,
  customers.customer_key,
  FROM
  bl1_gain_adj,
  customers,
  bl1_gain,
  bl1_reply_code
  WHERE
  bl1_gain.loan_key = customers.loan_key
  AND bl1_gain.customer_key = customers.customer_key
  AND bl1_gain.receiver_customer = customers.customer_no
  AND bl1_gain.cycle_seq_no = customers.cycle_seq_no
  AND bl1_reply_code.gain_code = bl1_gain.gain_code
  AND bl1_reply_code.revenue_code = 'RC'
  AND bl1_gain_adj.gain_seq_no = bl1_gain.gain_seq_no
  AND bl1_gain_adj.customer_key = bl1_gain.customer_key;
  
  Records in tables
  ---------------
   bl1_gain_adj = 100 records    
   customers = 10 Million records   
   bl1_gain = 1 Million records   
   bl1_reply_code = 100 million records
  </code></pre>