Which query hint should you use?

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?

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

Show Hint

← Previous question

Next question →