You have a table with a string column

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

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *