Plan Guides in SQL Server 2008

Hi Guys,

Plan Guides is one of the system procedure which in newly introduced in SQL Server 2008 i.e

sp_create_plan_guides which is likely for to optimize the performance of queries.This procedure can be very useful when yo cannot change the text directly.

By using OPTION Clause that contanins the query hints for optimize the query performance

syntax for Plan Guides.

sp_create_plan_guide

@name =N 'example',

@stmt =N 'select * from table where country = @country',

@type = N'object',

@module_or_batch = N'tablename',

@parms = null,

@hint = N'option (optimize for @country = 'uk')'

Hope U guys got the minimum basic idea about the Plan Guides in SQL SERVER 2008