http://blogs.msdn.com/b/joesack/archive/2010/04/23/friday-afternoon-case-of-the-mystery-scan-versus-seek.aspxSo I just got finished with a Friday afternoon head scratcher (that luckily had a resolution). Problem: Ad hoc query with a predicate that references a literal value does an index seek. 0 second execution. Ad hoc query that defines a localen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/joesack/archive/2010/04/23/friday-afternoon-case-of-the-mystery-scan-versus-seek.aspx#10033340Thu, 01 Jul 2010 09:45:12 GMT91d46819-8472-40ad-a661-2c78acb4018c:10033340Toph<p>well, so simple yet so informative!! job well accomplished</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10033340" width="1" height="1">