Tag Archives: find index typ

SQL : How to Find Unused Indexes details

The Dynamic Management View (DMV) named sys.dm_db_index_usage_stats that track Β index usage details of the database.Β This DMV gives an information about an index which is being updated but not used in any seeks, scan or lookup operations. The below query list … Continue reading

Posted in SQL, Uncategorized | Tagged , , , | Leave a comment