Jerry Barnes wrote: > 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)
How does the execution plan look? ISTM you want a mergejoin with vfrm_sae as the driving table and v_sae_jna_mr as the inner table. If your execution plan shows differently, make sure you have clustered indexes on recordthread and i_recordThread and try again. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274342 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4