• Would you think it advisable to run sp_recompile after doing a re-index of tables? We have bad performance problems on our server at the moment and wonder if this would help or hinder...?

  • sp_recompile toggles a stored procedure or trigger to be recompiled the next time it is run, but it won't actually do the recompile. Since the indexes are rebuilt, that should typically trigger the recompile as well.

    K. Brian Kelley



    K. Brian Kelley

  • May or may not have the effect of making things better. If you made index changes then I believe it would but without all you can do is try. System may lag for a bit but after the items recompile an run a few times they will pick back up at least as good as before. sp_updatestats may offer a bit of help thou.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply