title: What we can add to make Query Run faster in Oracle ? Below is Oracle Query slowness
body: <pre><code>SELECT NVL(SUM(TRN.ACCRUALPTS), 0) AS ACCRUALPTS
    FROM TrsanctionTable REQ INNER JOIN 
         TRSANCTIONTABLEREQ TRN ON TRN.TRNREQID = REQ.TRNREQID INNER JOIN 
         CARDTABLE CARD ON CARD.CARDID = TRN.CARDID
   WHERE TRN.CUSTOMERID = 4082
     AND TRN.STATUSCODE = '2220'
     AND REQ.STATUSCODE = '00'
     AND TRN.BATCHID IS NULL;
  </code></pre>
  <p>Above Query which is taking much time to execute, Could you suggest me that how I can rewrite or change this query to run faster. My team suggest to Add composite index on this query.</p>
  <p>Is their anything else that can work to reduce the cost of this QUERY</p>
  <p><strong>COST OF THIS QUERY IS 102K</strong></p>
  <blockquote>
  <p>NOTE: Indexing Already Apply on Single columns.</p>
  </blockquote>
  <p><a href="https://i.stack.imgur.com/vZWyO.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vZWyO.jpg" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/7WS1N.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7WS1N.jpg" alt="enter image description here" /></a></p>