C H A P T E R 6
Bookmark Lookup Analysis
To maximize the benefit from nonclustered indexes, you must minimize the cost of the data retrieval as much as possible. A major overhead associated with nonclustered indexes is the cost of excessive key lookups, commonly known as bookmark lookups, which are a mechanism to navigate from a nonclustered index row to the corresponding data row in the clustered index or the base table. Therefore, it makes sense to look at the cause of bookmark lookups and to evaluate how to avoid this cost.
In this chapter, I cover the following topics:
- The purpose of bookmark lookups
- Drawbacks of using bookmark lookups ...
Get SQL Server 2008 Query Performance Tuning Distilled now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
