title: Delete statement in SQL is very slow
body: <p>I have statements like this that are timing out:</p>
  
  <pre><code>DELETE FROM [table] WHERE [COL] IN ( '1', '2', '6', '12', '24', '7', '3', '5')
  </code></pre>
  
  <p>I tried doing one at a time like this:</p>
  
  <pre><code>DELETE FROM [table] WHERE [COL] IN ( '1' )
  </code></pre>
  
  <p>and so far it's at 22 minutes and still going. </p>
  
  <p>The table has 260,000 rows in it and is four columns.</p>
  
  <p>Does anyone have any ideas why this would be so slow and how to speed it up?
  I do have a non-unique, non-clustered index on the [COL] that i'm doing the WHERE on.
  I'm using SQL Server 2008 R2</p>
  
  <p>update: I have no triggers on the table.</p>