Hi, SQL Server DBA should monitor all indexes and which of indexes are using and which are not.   If the index is not using or using very rare then SQL Server DBA should drop it to not provide extra load to the database. You can find all indexes usage statistic with following script. Script will … Continue reading SQL Server Unused Index