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"