title: Need help to fine tune SQL inner join query - Oracle
body: <p>I need help to fine tune below Oracle SQL query, which is running for long hours.</p>
  
  <pre><code> SELECT 
       MIN( E.MKT_PRC),
       MAX( E.MKT_PRC)
   FROM 
       GL_VESTINGPRIME_RPT VP 
       INNER JOIN GRANTZ G 
           ON G.GRANT_NUM = VP.GRANT_NUM 
           OR G.XFER_ORIG = VP.GRANT_NUM 
       INNER JOIN EXERCISE E 
           ON E.GRANT_NUM = G.GRANT_NUM
   WHERE 
       VP.RUNTIME_ID = :B4 
       AND VP.PLAN_NUM = NVL(:B3, VP.PLAN_NUM) 
       AND E.EXER_DT BETWEEN :B2 + 1 
       AND :B1 
  </code></pre>