Hi,
Please help anyone. I am a bit unclear how to create the right indexes to optimize the following query for my ad displaying script
SELECT * FROM members WHERE approved=1 AND id !='$ID' AND targeting='$targeting' AND (((disp_others/disp_ratio)+bonus_credits-disp_yours)>=1) ORDER BY blank,last_date
I know you can index on multiple fields but what about do I do a about the 'disp_others/disp_ratio)+bonus_credits-disp_yours)>=1' bit.
Any help greatly appreciated
Will
Please help anyone. I am a bit unclear how to create the right indexes to optimize the following query for my ad displaying script
SELECT * FROM members WHERE approved=1 AND id !='$ID' AND targeting='$targeting' AND (((disp_others/disp_ratio)+bonus_credits-disp_yours)>=1) ORDER BY blank,last_date
I know you can index on multiple fields but what about do I do a about the 'disp_others/disp_ratio)+bonus_credits-disp_yours)>=1' bit.
Any help greatly appreciated
Will