Archives of the TeradataForum

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

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

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.

Thanks,

Ravi

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