How to improve the performance of the following query?

[vivek samantray]

We have some batch proceeses running.In which we have some driver queries one of the queries is listed below.I am working on the performance improvement of these queries .I have done proper indexing in which performance has been incresed.But we need to furtehr impriove the performance.Can you please suggest me how can i further modify the below query for performance

SELECT DISTINCT e.ELG_EVNT_ID,
                e.ELG_ENTITY_ID,
                e.ELG_DPT_ID,
                e.PART_ID,
                e.OU_ID,
                e.ELG_ACNT_ID
  FROM ELG_ELGBLTY        e,
       NGP_NOTF_GNT_PMTR  n,
       SBD_SYS_BSNS_DTS   s,
       DPT_DPOT_EVNT_DTLS d,
       EDD_EVNT_DT_DTLS   f,
       IAC_IMPCT_ACTN     i
 WHERE e.ELG_ENTITY_ID = d.DPT_ENTITY_ID AND e.ELG_EVNT_ID = d.DPT_EVNT_ID AND
       e.ELG_DPT_ID = d.DPT_DPT_ID AND e.ELG_ENTITY_ID = n.NGP_ENTITY_ID AND
       e.ELG_EVNT_ID = n.NGP_EVNT_ID AND e.ELG_DPT_ID = n.NGP_DPT_ID AND
       e.ELG_ENTITY_ID = s.SBD_ENTITY_ID AND
       e.ELG_ENTITY_ID = f.EDD_ENTITY_ID AND e.ELG_EVNT_ID = f.EDD_EVNT_ID AND
       e.ELG_DPT_ID = f.EDD_DPT_ID AND e.ELG_ENTITY_ID = i.IAC_ENTITY_ID AND
       e.ELG_EVNT_ID = i.IAC_EVNT_ID AND e.ELG_DPT_ID = i.IAC_DPT_ID AND
       e.PART_ID = f.PART_ID AND e.OU_ID = f.OU_ID AND f.STATUS = 'AUTHD' AND
       d.STATUS = 'AUTHD' AND (n.STATUS = 'AUTHRIZE' OR n.STATUS = 'PRCSD') AND
       s.STATUS = 'AUTHRIZE' AND e.ELG_STATUS = 'AUTHRIZE' AND
       s.SBD_BTCH_IND = '0' AND e.ELG_SND_NTFCTN_IND = '1' AND
       n.NGP_NOTF_TYPE = 'PREANNC' AND n.NGP_GNT = '1' AND
       e.ELG_DPT_ACNT_IND = '0' AND i.IAC_ACTN_TYP = 'NEWH' AND
       i.STATUS = 'TBPRCD' AND e.OU_ID = s.OU_ID AND e.OU_ID = n.OU_ID AND
       e.PART_ID = 1 AND e.PART_ID = n.PART_ID AND e.PART_ID = d.PART_ID AND
       e.PART_ID = i.PART_ID AND e.OU_ID = i.OU_ID AND e.ELG_EVNT_ID >= '0000000000' AND
       e.ELG_EVNT_ID <= '9999999999'
 ORDER BY e.ELG_ENTITY_ID, e.ELG_EVNT_ID, e.ELG_DPT_ID

[mwasif]

Run an EXPLAIN and post the output here.

[vivek samantray]

Please find the output for explain plan

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
| Id | Operation | Name | Rows | B
--------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 |
| 1 | SORT ORDER BY | | 1 |
| 2 | HASH UNIQUE | | 1 |
| 3 | TABLE ACCESS BY INDEX ROWID | EDD_EVNT_DT_DTLS | 1 |
| 4 | NESTED LOOPS | | 1 |
| 5 | NESTED LOOPS | | 1 |
| 6 | NESTED LOOPS | | 1 |
| 7 | NESTED LOOPS | | 1 |
| 8 | NESTED LOOPS | | 1 |
| 9 | TABLE ACCESS BY INDEX ROWID| IAC_IMPCT_ACTN | 1 |
| 10 | INDEX RANGE SCAN | PERF_IAC_ACTN_TYPE | 1 |
| 11 | TABLE ACCESS BY INDEX ROWID| ELG_ELGBLTY | 1 |
| 12 | INDEX RANGE SCAN | ELG_INDEX_2 | 99 |
| 13 | TABLE ACCESS BY INDEX ROWID | NGP_NOTF_GNT_PMTR | 1 |
| 14 | INDEX UNIQUE SCAN | SYS_C00459902 | 1 |
| 15 | INDEX RANGE SCAN | DPT_INDEX_1 | 1 |

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
| 16 | TABLE ACCESS BY INDEX ROWID | SBD_SYS_BSNS_DTS | 1 |
| 17 | INDEX UNIQUE SCAN | SYS_C00459464 | 1 |
| 18 | INDEX RANGE SCAN | EDD_EVNT_DT_DTLS_INDEX | 1 |
--------------------------------------------------------------------------------
Note
-----