I have the following sql server query:
delete a from list a
inner join transactions b
on a.sono = b.sono
the list table has around 500,000 rows and the transaction table has around 5,000,000 rows
I have a non-clustered index on the sono field for each table. The sono field is not unique in each table.
the query is taking over 3 hours, is there any way to do the delete faster?