/**
* Find unnecessary indexes. Having to maintain an index is expensive from both a latency
* and a storage standpoint. If we can get rid of any redundant indexes, then we can save
* space and improve performance by dropping them.
*/
SELECT
	-- The unnecessarily indexed columns.
	t.table_name,
	t.redundant_index_name,
	t.redundant_index_columns,
	-- The index that is already handling the aforementioned columns.
	t.dominant_index_name,
	-- The SQL statement you can execute in order to drop the unnecessary index.
	t.sql_drop_index
FROM
	sys.schema_redundant_indexes t
WHERE
	t.table_schema = @db
;