Microsoft
70-459 · Question #60
You execute usp_SelectEmployeesByName multiple times, passing strings of varying lengths to @LastName. You discover that usp_SelectEmployeesByName uses inefficient execution plans. You need to…
The correct answer is B. OPTION (OPTIMIZE FOR UNKNOWN). See the full explanation below for the reasoning.
Question
You execute usp_SelectEmployeesByName multiple times, passing strings of varying lengths to @LastName. You discover that usp_SelectEmployeesByName uses inefficient execution plans. You need to update usp_SelectEmployeesByName to ensure that the most efficient execution plan is used. What should you add at line 31 of StoredProcedures.sql?
Options
- AOPTION (ROBUST plan)
- BOPTION (OPTIMIZE FOR UNKNOWN)
- COPTION (KEEP PLAN)
- DOPTION (KEEPFIXED PLAN)
How the community answered
(34 responses)- A3% (1)
- B71% (24)
- C18% (6)
- D9% (3)
Community Discussion
No community discussion yet for this question.