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 » indexing » index seek   (RSS)
  • Stupid Index Seek Tricks - using Included Columns

    Usually, we think of index seeks (a possible Query Execution Plan operation) as using the b-tree index to pick out a row and then quickly pass that row to the next operation. But the index seek has special powers: when the conditions are right, it can examine non-key columns and filter based on those values inside the index seek operation. When ...
    Posted to Paul Nielsen (Weblog) by Paul Nielsen on August 14, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement