Sean Lange (2/25/2013)
That only shows index usage. If your queries are not sargable or you have a heap your results may not be exactly what you are looking for.
A scan is a use of an index, and the index usage DMV does include heaps and clusters. SELECT * from HeapTable will put an entry in that DMV.
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