Which of the following is the argument being discussed?

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 statistical data instead of the initial
values for all local variables when the query is compiled and optimized.
Which of the following is the argument being discussed?

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 statistical data instead of the initial
values for all local variables 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:



Leave a Reply 2

Your email address will not be published. Required fields are marked *