How to Fix a Bookmark Lookup

SQL Server performance tuning guru Grant Fritchey explains how to fix a bookmark lookup - a common cause of poor performance. He'll show you how to diagnose it and how to fix it!

I'm currently working for FM Global, an industry leading engineering & insurance company, as a DBA. I've done development of large scale applications in languages such as VB, C# and Java. I've worked in SQL Server from the hoary days of 6.0. My nickname at work is the "The Scary DBA." I even have an official name plate with it. I wear it proudly. I was awarded a Microsoft MVP in April of '09.

Leon on 11/2/2008

awesome info.

Stephen Dyckes on 12/9/2008

Another good point to add to this would be if the "covering index" will still be used efficiently when only using the indexed column and not the included columns.

Dave on 12/9/2008

What impact on the physical structure of the index does the "include" impose (i.e. size, performance, etc.).

1F238A13BE on 12/9/2008

Good example. Thank you.

Purushtham Kumar katakam on 12/11/2008

good

Michael on 12/12/2008

Maybe add a brief mention on why NOT to use the included columns. I might think that ALL columans should always be indcluded.

titokapotito on 12/18/2008

Great Tip, thanks for the video.... Looking forward to see more videos in this page

Satyabodhi Densmore on 1/2/2009

Should note that INCLUDE columns are not supported in UNIQUE constraint definitions but only in CREATE INDEX statements.

tim cronin on 1/8/2009

Excellent