Index - Histogram

Dear Experts,

We are on 19.17 database version,2 node RAC.

We have a long running program which takes around 4 hours to complete. We have enalbed trace and did a tkprof. Below one is the top sql.

SQL ID: 7mbnuz8ys6hu4 Plan Hash: 1403729026


SELECT MAIN_CATEGORY,SUB_CATEGORY,CHILD_CATEGORY,PARTICULARS
FROM
 XXTTD_EXPENDITURE_ACCT_MAPPING WHERE ACCOUNT_CODE=:B1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        3      0.00       0.00          0          0          0           0
Execute 753485     12.74      12.70