You have a table that contains a string column. Most of the rows have the same value. You
need to create a multistep stored procedure that meets the following requirements: •
Accepts a text input parameter • Provides optimal performance for all input values • Has
only one step using the input parameter as a predicate What should you use?
A.
sp_recompile
B.
WITH RECOMPILE
C.
sp_configure
D.
a RECOMPILE query hint