Viewing 2 posts - 1 through 2 (of 2 total)
kwiggans (5/20/2010)
The actual execution plan shows an index scan is performed on tbl with an estimated subtree cost of 6.19.
...
The actual execution plan uses an index seek on both...
May 20, 2010 at 6:10 am
#1170038
Dynamic SQL should be last resort - but sometimes it is unavoidable. Please have a look this article regarding dynamic sql. http://www.sommarskog.se/dynamic_sql.html
May 19, 2010 at 9:52 pm
#1169850