|
|
|
|
|
|
|
|
|
Creating a Plan Guide for a Parameterized Statement
Plan guides are a great tool to know, providing a simple way to tweak the behavior of a query when you're not able to change the source statement directly. Today we'll show you how to create a plan guide for a parameterized statement executed via sp_executesql, and we'll throw in a demo of using OPTIMIZE FOR as a bonus!
|
|
|
|
Duration:
|
2
mins
56
secs
|
|
Skill Level:
|
100
|
|
Rating:
|
4.24
out of 5
|
|
Publish Date:
|
August 31, 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
|
|
good
|
|
|
Excellent presentation, though I do not know what a plan guide is as I noted last evening. Just one more item on my agenda to research.
|
|
|
Scripts?
|
|
|
As some others pointed I need to do a research on the plan guide
|
|
|
no use
|
|
|
so how do u use the plan guide ?
|
Must Be Logged In
|
|
|
|
|