On 1/2/07, Dan G. Switzer, II <[EMAIL PROTECTED]> wrote: > > Sometimes explicitly specifying the join hints can help if MSSQL is having > problems determining the best execution plan at runtime: > > http://blog.pengoworks.com/blogger/index.cfm?action=blog:567 > > I'd only recommend specifying join hints if you're seeing a huge > difference > in execution times. The most optimal plan can also change over the > lifetime > of your database, so while a join hint may help you today, it might cause > performance issues down the road as your database and schema changes. It's > just something to keep an eye on when you do manually specify join hints.
Dan, good entry. Thanks for sharing. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265469 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4