Post reply

DBCC Reindex

  • August 3, 2009 at 9:52 am

    #213111

    Hi All,

    Quick question; Does the update statistics at the end of the rebuild indexes job cause all query plans to be re-compiled?

    Thanks

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

  • August 3, 2009 at 1:14 pm

    #1033852

    Yes. When the index rebuilds, as oppose to reorganize, the statistics are updated and the procedures referncing those statistics are all marked for recompile.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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