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

Confio Ignite

Which Indexes Are Used By My Query?

I did this video in reponse to a question posted to an earlier one about index hints. It's a good question, and a good introduction to some of the many details you can find in query plans. We'll look at how to read the plan and dig into the detailed properties, and even how to examine the XML plan to see if index usage is being forced.

Duration:
2 mins 53 secs
Skill Level:
100
Rating:
4.24 out of 5
Publish Date:
September 03, 2010
Which Indexes Are Used By My Query? You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Andy Warren
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

References

There are no downloads or recommended reading links for this video

Comments
Denise Yu on 9/7/2010
It's good video show...

Marcelo Marim on 9/7/2010
cool

Sneha on 9/7/2010
this is good. it says i don't have access to the Virtual pass live meeting. I used teh same link that was sent in a email

Praneeth on 9/7/2010
ok

esteban on 9/7/2010
im a latinamerican, and my native language is spanish, might if put more quality video i can see that you pointed out in the video. Thanks

Talha on 9/7/2010
I never knew that you can force a certain index to run for a query. Good knowledge, thanks.

Leonard Peoples on 9/7/2010
Very helpful

Kenneth Wymore on 9/7/2010
clear and concise. Thanks!

Jonathon Moorman on 9/7/2010
well done. i had not realized that you could determine index hints thru the query plan. thanks for sharing!

Michael on 9/7/2010
Bandwidth is really hurting the usefulness of these great videos. Thank you for providing them, though. They're wonderful.

Ron on 9/7/2010
Good presentation.

Nandakumar on 9/7/2010
Nice video, worth to watch

D151BB6B9F on 9/7/2010
I can no longer open these videos in Firefox. What happened?

upzone on 9/7/2010
Wonderful

Charlie Bruno on 9/8/2010
As usual, extremely informative.

Simon Day on 9/8/2010
Another Great Video

Todd DeLand on 9/9/2010
Thank you!

kochu.vinod on 9/11/2010
good one

WChaster on 9/13/2010
very simple and clear, thanks

011A0851DF on 9/14/2010
Good job Andy

HD on 9/18/2010
Nice

Mark Holahan on 10/7/2010
Warren's a pro.

Dean Gross on 12/14/2010
tip about finding the forceindex setting in the xml was a nice addtion. These types of tips make these videos very educational.

MohanD on 2/25/2011
Good



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