You notice that for a particular set of parameter values the following query sometimes executes
quickly and other times executes slowly. You also notice that 90 percent of the rows in the Address
table
contain the same value for the city. SELECT AddressId,
AddressLine1,
City,
PostalCode
FROM Person.Address
WHERE City = @city_name
AND PostalCode = @postal_code
You need to use a query hint that, for the particular set of parameter values, will result in a more
consistent query execution time. Which query hint should you use?
A.
FAST
B.
MAXDOP
C.
OPTIMIZE FOR
D.
PARAMETERIZATION FORCED