Post reply

Query to check if indexes have been rebuilded

  • October 9, 2014 at 8:44 am

    #311659

    Hi there!

    Is there a way to know, just by running a single query, if indexes of a specific database have been rebuilded?

    Regards

  • October 9, 2014 at 8:49 am

    #1751328

    I guess you could check sysjobs and see when the last time the index rebuild job ran. Other than that, there's no easy way to track when an index was last rebuilt.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 10, 2014 at 4:06 am

    #1751542

    GilaMonster, thanks for your tip.

    Regards

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

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