You execute usp_TestSpeakers. You discover that usp_SelectSpeakersByName uses inefficient execution plans.
You need to update usp_SelectSpeakersByName to ensure that the most efficient execution plan is used. What should you add at line 30 of Procedures.sql?
A. OPTION (FORCESCAN)
B. OPTION (FORCESEEK)
C. OPTION (OPTIMIZE FOR UNKNOWN)
D. OPTION (OPTIMIZE FOR (@LastName= 'Anderson'))
Correct Answer: C
Explanation
Explanation/Reference:
Explanation: http://msdn.microsoft.com/en-us/library/ms181714.aspx
No comments:
Post a Comment