August 22, 2007 01:22 PM
Combining SQL and TEMPLATE Plan Guides
Creating two sets of plan guides gives you more control over query performance
Rating:
(0)
SQL Server Magazine
InstantDoc ID #96634
TEMPLATE plan guides allow two optimization hints, PARAMETERIZATION SIMPLE
and PARAMETERIZATION FORCED, which give you some control over SQL Server 2005's
query autoparameterization feature. (For more information about autoparameterization,
see "Controlling Parameterization," August 2007, InstantDoc ID 96349.) These
hints, which are actually the only hints that TEMPLATE plan guides can use,
force SQL Server to always use the same plan for an entire "class" of queries
and to tre...
...This article is for paid Professional Members only.
Already a Professional Member? Please log in now: