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 » 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
Privacy Statement