title: How to read the recommendations from DBA?
body: <p>I want to know / learn the difference between NESTED LOOPS and Hash join. for this purpose I posted this question. The query and explain plan are very lengthy, so these are not posted here. </p>
  
  <p>I have the following recommendations by DBA, can anyone explain what is needed by the new execution plan? </p>
  
  <p><strong>Oraiginal Execution plan 1</strong>
  <a href="https://i.stack.imgur.com/Y9cy1.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Y9cy1.jpg" alt="enter image description here"></a></p>
  
  <p><strong>New Execution plan 1</strong>
  <a href="https://i.stack.imgur.com/hgyHY.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hgyHY.jpg" alt="enter image description here"></a></p>
  
  <p>I think its need to remove the NESTED LOOPS, how to remove these NESTED LOOPS?</p>