Reset SQL Server Index usage

Question

I use below query to analyze usage of index in SQL Server.

SELECT * 
FROM sys.dm_db_index_usage_stats A
WHERE A.database_id = DB_ID()

How can reset all data from this system table?

Answer 1

What do you mean by reset .. do you want to reset the index usage statistics in the table?

Taken from Here

Usage statistics: These are found in sys.dm_db_index_usage_stats. Index usage statistics keep track of things like seeks and scans from SELECT queries. They are not persisted and get reset on restart of sql server. These statistics also get reset if the underlying index is rebuilt "ALTER INDEX ... REBUILD", but not with "ALTER INDEX ... REORG"

As said, you can't reset it manually. Take a look at this post which certainly says the same

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/08eb7b79-64a3-4475-bfc3-69715aec8381/resetting-dmdbindexusagestats-without-restarting-or-detaching-a-database