Hello,
I have the following query and I am wondering if there is a better way to write it to make it faster.
ThanksCode:SELECT * FROM MEMBERS WHERE ACCOUNT_BALANCE <= (0.10 * INVOICE_BALANCE) AND NOT EXISTS (SELECT * FROM ELIGIBILITY WHERE MEMBER.SSN = ELIGIBILITY.SSN) AND NOT EXISTS (SELECT * FROM UPDATES WHERE MEMBERS.SSN = UPDATES.SSN) AND CONTRACT_STATUS IN ('AC','RS','PD') AND INVOICE_CREATE_DATE >= cdate('2013-10-01');