Any ideas on how I might speed this up? I know sub-selects are seriously
slow, I'm not sure what else can be done though.
DELETE from applicants_states WHERE app_id IN (SELECT s.app_id FROM
applicants_states AS s, applicants AS a WHERE s.app_id=a.app_id AND
(a.created + '90 days') < 'now' AND a.resubmitted < '10-03-1999')
Thanks!
- Mitch