title: DELETE Command is too slow in a Table with Clustered Index
body: <p>I have a rather big table named FTPLog with around 3 milion record I wanted to add a delete mechanism to delete old logs but delete command takes long time. I found that clustered index deleting takes long time.</p>
  
  <pre><code>DECLARE @MaxFTPLogId as bigint
  SELECT @MaxFTPLogId = Max(FTPLogId) FROM FTPLog WHERE LogTime &lt;= DATEADD(day, -10 , GETDATE())
  PRINT @MaxFTPLogId
  DELETE FROM FTPLog WHERE FTPLogId &lt;= @MaxFTPLogId
  </code></pre>
  
  <p>I want to know how can I improve performance of deleting?</p>