Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 01 Mar 2011 @ 11:39:34 GMT

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

Subj:   Re: END TRANSACTION step - long when deleting
From:   Ravi.Singh

Hi Tomas,

Regarding you point #3, It's not always true that INSERT/UPDATE/DELETE always do table maintenance. There are some special cases when they defer the work to END TRANSACTION Step.

Delete step might not be actually deleting rows here. It may be just marking the rows which qualifies for delete. It would be END TRANSACTION step who may be doing real delete from table by reading those markings. This approach is helpful when user aborts a transaction prematurely( before END TRANSACTON Step arrives) as we need not to reinsert rows into table (since they were not deleted at all).

All we need to do is to remove the markings done by DELETE step.



  <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