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?)
Kelsey Thornton
MBCS CITP