ITPUB

Jun 21, 2016 · Databases

Eliminate Bookmark Lookups in SQL Server: Index Strategies Explained

This article explains what bookmark (key) lookups are in SQL Server, shows how they appear in execution plans, and presents three practical indexing techniques—clustered indexes, covering indexes with INCLUDE, and index intersection—to remove the extra I/O overhead.