Determine last index rebuild or reorg

• ken.trock

  SSCertifiable

  Points: 5147

  More actions

  January 5, 2012 at 10:46 am

  #248596

  Hi. Would sys.dm_db_index_usage_stats.last_system_update be the place to look for the last time an index got rebuilt or reorganized? From there chain to sys.tables and sys.indexes for table and index name?

  Thanks,

  Ken

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 5, 2012 at 10:50 am

  #1429208

  No.

  Unless you keep a record, there's no history of when an index was created or 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