ReOrganizeing and Index stats

  • Does Reorganizing indexes also loose the Index usage stats?

  • No. The information in sys.dm_db_index_usage_stats will persist after a reorganization. A rebuild will remove the entry for that index in sys.dm_db_index_usage_stats, and then stats collection will start over.

    Cheers!

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

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