Kelsey Thornton (1/27/2010)
CirquedeSQLeil (1/26/2010)
if one examines execution plans for these two queries and run them together, the query optimizer treats them as the same execution plan and equates both queries to the same cost.Hmmmm. Wonders if they are optimised to a "(s)lowest common denominator" 🙂
(Being a bit of a lightweight here I don't know how to examine the execution plans. Is that part of the SQL Profiler?)
You can click on the Include Actual Execution Plan Icon in Management Studio before running your query. You will get the actual execution plan in the result.
Clicking on the Display Estimated Execution Plan displays the Estimated Execution Plan.
Thanks
Saurabh Dwivedy
___________________________________________________________
My Blog: http://tinyurl.com/dwivedys
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537