For this condition, there are around 600000 records available in the table.
This query takes more than 1 hour to complete.
Can any please tell me , how to optimize the following query to improve its performance.
FROM PROD.TABLE1 A,
WHERE A.ADR_FMT = 'EMAIL'
AND A.ZIP5_CDE = ' '
AND B.ADDR_TYPE = 'EMAIL'
AND A.ZIP5_CDE = B.ZIP5_CDE
AND A.ADR_ID = B.ADR_ID