You have a table with a string column. A lot of data is duplicated. Need to optimize a stored procedure for performance with the following criteria
+ stored procedure takes a string parameter as input
+ stored procedure must be optimized for all input params
+ only one SELECT statement uses the string input parameter
A.
RECOMPILE query hint on the SELECT statement
B.
sp_reconfigure
C.
sp_recompile
D.
alter stored procedure WITH RECOMPILE option