Up until SQL Server 2008 R2, using index usage stats entries in
to make some assumptions over index design and workload patterns was common.
However, in SQL Server 2012 and higher versions, entries in this DMV were reset with every index rebuild, so this was no longer a viable way of tracking index usage patterns. This was clearly voiced out in Connect items, such as
and direct customer feedback.