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