How about something like this: SELECT F.pid, F.acrostic, F.recid, F.recordthread, F.aed_onset, F.d_form FROM vfrm_sae F WHERE NOT EXISTS (SELECT 1 FROM v_sae_jna_mr WHERE recid=F.recordthread)
Not sure it'll be much faster, but it's worth a try. Cheers, Kris > The following query is slow. I'd like to speed it up a bit. Any > suggestions would be appreciated. > > SELECT > F.pid, > F.acrostic, > F.recid, > F.recordthread, > F.aed_onset, > F.d_form > FROM > vfrm_sae F > LEFT OUTER JOIN > v_sae_jna_mr M > ON > F.recordthread = M.i_recordThread > WHERE > (M.i_recid IS NULL) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274327 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
