Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 01 Mar 2011 @ 10:04:21 GMT

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

Subj:   Re: END TRANSACTION step - long when deleting
From:   Dieter Noeth

Sidana Sanjeev wrote:

  This is due to the Transient Journals. During a Delete operation, Transient Journals(TJs) may be required for a rollback.  

Deleting a full partition doesn't always use Transient Journal, it's supposed to work like DELETE ALL using fastpath, if it's the last statement in a transaction and there's no Join Index/FK (equal to a TRUNCATE).

The only bad thing: Explain doesn't tell if it's fastpath...

  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.  

An MLoad Delete used to be always faster than a SQL Delete, but it's no longer true, see above.


  <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