Archives of the TeradataForum

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

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

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.

HTH

Thanks

Sanjeev

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