title: DELETE performance in SQL Server on clustered index, large table
body: <p>I have a table with more than 20 million rows, and when i do:</p>
  
  <pre><code>DELETE [Table] WHERE ID = ?
  </code></pre>
  
  <p>It takes over 40 seconds. The ID column is clustered.</p>
  
  <p>Is this what you could expect? or is it possible to optimize this?</p>