THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Indexes » query plans » nonclustered index   (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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement