|
|
|
|
|
|
|
|
|
Using Index Hints in a Query
Index hints are a way to force SQL Server to use a particular index to process a query. It won't change the results you get, but it can dramatically change performance in a very few cases where the optimizer fails to find the right index. It can cause queries to fail if the index is renamed or deleted. It's a tool that you will rarely use, but when you need it, it's a very nice thing to know about.
|
|
|
|
Duration:
|
3
mins
35
secs
|
|
Skill Level:
|
100
|
|
Rating:
|
4.29
out of 5
|
|
Publish Date:
|
September 02, 2010
|
|
|
|
About the Author
|
|
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
|
|
Nice. Could have used this on an interview I went on yesterday....
|
|
|
great lesson
|
|
|
How do you know if the current query is already using the index, to decide whether or not you want to force an index on the query?
|
|
|
any more interesting about table hint?
|
|
|
nice one.
|
|
|
good
|
|
|
I liked this video.
|
|
|
Simple and clear to understand the use of INDex Hint.
|
|
|
Provide the text of this video too.
|
|
|
This is extremely useful information
|
Must Be Logged In
|
|
|
|
|