THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Indexes » nonclustered in... » query plans   (RSS)
Sorry, but there are no more tags available to filter with.
  • Geek City: Join With Me!

    I remember one of the most surprising changes in SQL Server 2000 2005 was how the graphical plans showed the use of a nonclustered index to seek, and the plan included something that looked like a JOIN to find rows in the base table.  Here’s an example. Although I used SQL Server 2008R2, the graphical plan will be pretty similar to what it ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on February 14, 2013
Privacy Statement