Received: from icebox.venux.net (icebox.venux.net [216.120.166.10]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA89254 for ; Mon, 10 Apr 2000 16:33:15 -0400 (EDT) (envelope-from mitch@venux.net) Received: from servbox.venux.net (matrix.venux.net [216.120.166.5]) by icebox.venux.net (Postfix) with ESMTP id 1ACBE26202 for ; Mon, 10 Apr 2000 16:37:08 -0400 (EDT) Received: from doot (doot.venux.net [10.0.0.65]) by servbox.venux.net (Postfix) with SMTP id EF04A2BD82 for ; Mon, 10 Apr 2000 16:33:35 -0400 (EDT) Message-ID: <004901bfa32c$63c051e0$4100000a@venux.net> From: "Mitch Vincent" To: References: <17328.955396227@sss.pgh.pa.us> Subject: Speedy query help.. Date: Mon, 10 Apr 2000 16:36:03 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200004/96 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