DELETE performance in SQL Server on clustered index, large table

Viewed 16965

I have a table with more than 20 million rows, and when i do:

DELETE [Table] WHERE ID = ?

It takes over 40 seconds. The ID column is clustered.

Is this what you could expect? or is it possible to optimize this?

3 Answers
Related