 |
 |
Archives of the TeradataForum
Message Posted: Tue, 01 Mar 2011 @ 10:04:21 GMT
| 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.
Dieter
| |
