title: Improving the performance of the following TSQL code
body: <p>I am using Sybase DB with TSQL.</p>
  
  <p>The follow snippet of TSQL code is very simple and I need to perform it several 100,000 times (large database) so I would really like to improve its performance in any way possible:</p>
  
  <pre><code>BEGIN TRANSACTION
  INSERT INTO
    DESTINATION_TABLE
  SELECT
    COLUMNS
  FROM
    SOURCE_TABLE
  WHERE
    ORDER_ID = @orderId
  
  DELETE FROM
    SOURCE_TABLE
  WHERE
    ORDER_ID = @orderId
  COMMIT TRANSACTION
  </code></pre>
  
  <p>As one can see, I am inserting and removing the same set of rows based on the same condition.</p>
  
  <p>Is there a way to improve the performance of this simple query?</p>
  
  <p>Thanks.</p>