Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by David Poole Intersect, Except, Union, All and Any RE: Intersect, Except, Union, All and Any
Allen Nugent
Right there with Babe
Points: 734
More actions
May 23, 2010 at 6:14 pm
#1171347
I'm sure I once read, here, that WHERE IN tends to be expensive. Your test results challenge this assertion. I wonder if SQL Server 2008 is optimising the execution plan a lot more than it used to.