http://blogs.msdn.com/queryoptteam/archive/2006/04/12/575241.aspxThe Optimizer model makes several assumptions when making plan choice decisions. These decisions can be false for particular queries and data sets, and sometimes this can cause plan issues. One such problem is called “The Sorted Seek Problem” by the Optimizeren-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/queryoptteam/archive/2006/04/12/575241.aspx#693425Wed, 09 Aug 2006 19:26:32 GMT91d46819-8472-40ad-a661-2c78acb4018c:693425MaldaerThis is an extremely useful post as it highlights some little known facts about how SQL Server determines the best course of action. &nbsp;I have a table that is in the region of about 50million rows with the appropriate indexes etc, but when I ran a query using a variable on the indexed column it decided to perform a full table scan instead of using the pre-defined index, needless to say I gave up waiting for the results to come back. &nbsp;I stumbled upon this article and added the &quot;with index=indexname&quot; and the results came back instantaneously.http://blogs.msdn.com/queryoptteam/archive/2006/04/12/575241.aspx#9361346Thu, 22 Jan 2009 04:56:19 GMT91d46819-8472-40ad-a661-2c78acb4018c:9361346Where is ROWID in Sql Server 2005 like Oracle ? - Page 2 | keyongtech<p>PingBack from <a rel="nofollow" target="_new" href="http://www.keyongtech.com/2149161-where-is-rowid-in-sql/2">http://www.keyongtech.com/2149161-where-is-rowid-in-sql/2</a></p>