Run SP_RECOMPILE after SP_UPDATESTATS

SP_UPDATESTATS refers to work against all user-defined tables in the current database.

For the stored procedures performance you need to recompile them in order to take the new plan in to the memory, so run SP_RECOMPILE for all or required stored procedures to compare the sequence of performance.

Leave a Reply

You must be logged in to post a comment.