Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am bit confused with terminology as official Microsoft SQL Server documentation including BOL refers to plan guide the one you create using sp_create_plan_guide proc. Does plan freezing is same thing or slightly different?. Reading Erland's great article here

There are two ways to set up plan guides, a general way, and a shortcut which is also known as plan freezing. General plan guides were introduced in SQL 2005, whereas plan freezing was added in SQL 2008.

I am reading plan freezing is when you create guide using sp_create_plan_guide_from_handle

Seeking a clarification on terminology being used, does plan guide and plan freezing is the same thing or they refer to slightly different way to stick the execution plan in the cache?

share|improve this question

1 Answer 1

up vote 3 down vote accepted

Yes, that is my understanding as well, and this post helps provide some examples for you to review.

Plan guides (plan freezing) in SQL Server 2005/2008

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.