Indexes can improve the speed of DELETE statements
One often-overlooked benefit of a nonclustered index in SQL Server is its impact on data deletion. When used properly, indexes can significantly enhance performance when retrieving rows for deletion. However, don’t overdo it, as indexes introduce extra overhead for inserting, updating, and deleting data.
TL;DR Indexes can improve the speed of DELETE statements.