Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 01 Mar 2011 @ 09:16:40 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: END TRANSACTION step - long when deleting
From:   Sidana Sanjeev

Hi Tomas,

This is due to the Transient Journals. During a Delete operation, Transient Journals(TJs) may be required for a rollback. But remember, that a rollback can take much longer than a delete operation.

So, if you are sure that you wont be affected by delete transaction getting failed and would not want rollback in any case, you can avoid the rollback and the use of TJs. You may perform the delete operation using Multiload delete.

Multiload delete does not use TJs and so never goes for a rollback though, if failed, it can start deleting from the same point if used with a checkpoint.

It is also an all-amp delete which is faster as it just deletes on the basis of block of rows unlike normal delete which deletes based on the PI index values.




  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023