When executing this simple SQL Delete statement, I'm getting a timeout from SQL Server:
DELETE FROM dbo.[User] WHERE Id = 95146
There are about 95.000 records in the table.
I thought it might be because of indexes on the table, so I've deleted all except from the primary key (Id) which is clustered, but this didn't help.
I've deleted all the statistics I created as well, but also without any effect.
What else can I do to optimize for this?
Kind regards, David