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

Download a free trial of SQL Backup now

What is a Clustered Index Seek?

This video explains what a clustered index seek is when looking at a query plan.

Duration:
0 mins 47 secs
Skill Level:
100
Rating:
3.44 out of 5
Publish Date:
September 09, 2008
What is a Clustered Index Seek? Watch Video Now  Watch it later!
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
Jason Wall on 10/30/2008
Great, but short.

Simon Doubt on 10/30/2008
Too short!

Simon Doubt on 10/30/2008
Agreed. A great topic, but too short.

Liang Zang on 10/30/2008
to short...

Tcharly Florestal on 10/30/2008
Good job.

Mohan on 10/30/2008
Not informative.

Chris Rock on 10/30/2008
It appears that some of the videos that we have made seem to be a little shorter than you would like. If you could, please use the "Suggest a video" link above and tell us what you would like to see. The videos that we had Grant do were very basic on purpose. They answer the question "What is an index scan?" or "What is a clustered index seek?". Someone new to performance tuning needs the basics and that is what these are for. We are planning a series on how to fix the various performance tuning issues and everyone here will know when they come out via the newsletter.

John O'Sullivan on 10/30/2008
Hi, Again an excellent video but very short. Topics such as Execution Plans could command a time span of 10-15 mins. I believe 10 - 15 allows time to cover topics in more depth without becoming over burdoned in detail and losing attention.

Charles Mandeville on 10/31/2008
Very helpful for training purposes

Grant Fritchey on 10/31/2008
I am sorry everyone thinks these are too short. As Chris said, the intention was to answer a simple question, not provide an extended lesson plan. Believe me, an extended lesson plan is possible on most of these topics.

Prasanna Prabhu on 11/28/2008
Short & concise. Excellent Video

1B5F4C7EBF on 12/9/2008
probably a little more detail would have been helpful, for instance, comparing the performance of a clustered index seek vs. clustered index scan, etc.

Tim Patterson on 7/2/2009
Grant, I really like that your videos are short and targeted. Thanks.

khanlala on 9/17/2009
very good

JohnG on 3/31/2010
short

Ravi Raj on 6/29/2010
good one



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