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
Code:
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
Comment