I've got a delete statement which is taking 40 secs to run. There's only a row to delete but it's taking 40 secs . The table has got foreign keys which references other tables. I have checked
indexes exist on these foreign key columns.
I have already updated statistics with fullscan on the this table.
DELETE FROM konten WITH(ROWLOCK) WHERE KONTONR = 123456
View Complete Post