Tag Archives: finding no of rows of a table

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