• If these 2 nonclustered indexes have only index seeks in sys.dm_db_index_usage_stats then most likely you can drop them without sacrificing performance too much, but if there are a lot of index scans then it may be better to keep them. At least until you identify what queries and why scan these indexes.


    Alex Suprun