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?
