raminshahab 0 Newbie Poster

I have three tables that I query. Problem is my ORACLE MIF table has 500,000 rows. And it takes more than 1 hour.

How can I reduce the time?

SELECT WB_FIELD_REQ.MODEL, WB_FIELD_REQ.MFG_SERIAL_NUMBER, CONFIG_SERIAL_NUMBER, SH_CONTRACTS.EQUIPMENT_ID, "", SH_CONTRACTS.SERVICE, "", SH_CONTRACTS.CONTRACT, "X", "", "X" 
FROM WB_FIELD_REQ 
INNER JOIN SH_CONTRACTS ON WB_FIELD_REQ.MFG_SERIAL_NUMBER=SH_CONTRACTS.MFG_SERIAL_NUMBER 
NOT IN (SELECT DISTINCT MFG_SERIAL_NUMBER FROM ORACLE_MIF WHERE PROJECT_NUMBER = "701") 
AND WB_FIELD_REQ.DEVICE="701"