SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Confio Ignite

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!

Duration:
1 mins 35 secs
Skill Level:
100
Rating:
4.46 out of 5
Publish Date:
September 09, 2008
How to Fix a Bookmark Lookup You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Grant Fritchey
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.

References

There are no downloads or recommended reading links for this video

Comments
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.

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

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

sunil on 4/27/2011
Excellent

Jonathan on 5/24/2011
Nice and concise explanation. Should help lots of people. Thanks Grant.

Dan Taylor on 5/24/2011
new trchnique - well introduced

Misael Chuc S. on 5/24/2011
good

6D31532EAE on 5/24/2011
More explanation on the INCLUDE statement would have been helpful.

huruy yohannes on 5/24/2011
Consequences of adding too many include columns in indexes?

revanth on 5/24/2011
nice video , it would be better to add explanation about seek predicates and outputlist in the exec plan of clustered index

Holck on 5/24/2011
INCLUDE is a new one for this developer. Great stuff. I would have liked to be able to see the full query text... flashed by and then the where clause dropped off the screen.

Paul E Richmond on 5/24/2011
Clear and concise.....

Andy Abel on 5/24/2011
Excellent reminder. More like this please!

George Heinrich on 5/24/2011
I liked this...but it would have been nice to have the video explain the difference between an index that uses the "include" phrase for columns and an index that just indexes those additional columns themselves (advantages/disadvantages/differences)

Frank Fernandez on 5/24/2011
As usual, excellent video!

david thomas on 5/24/2011
Good Tip

phani on 5/24/2011
good one

idris chambas on 5/24/2011
Excellent tip. Thanks, Grant.

Rajesh on 5/25/2011
Excellent !

Krishna on 5/25/2011
Excellent!

Michael Neymit on 5/25/2011
Nice video, but what's the difference between creating a covered index and using INCLUDE? It seems that in both cases the "extra" columns have to somehow become part of the index structure.

Bobby on 5/25/2011
Clear and concise. Thanks!

erick on 5/26/2011
Awsome!

Diana Dee on 5/28/2011
You might have made a second index that is covering (leaving the first) and showing the relative performance. Or, you might have shown the cost of the first query versus the cost of the second.

Prakash on 5/29/2011
Fantastic

Prashant Thakwani on 6/14/2011
Grant, you are great

Maurice Ivory on 10/31/2011
It was cool, I enjoyed this learning about this.



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions