You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing a query hint
argument that instructs the query optimizer to make use of a particular value for a local variable
when the query is compiled and optimized.
Which of the following is the argument being discussed?
A.
RECOMPILE
B.
ROBUST PLAN
C.
MAXDOP
D.
OPTIMIZE FOR UNKNOWN
E.
OPTIMIZE FOR
Explanation:
http://technet.microsoft.com/en-us/library/ms181714.aspx
?