Archives of the TeradataForum
Message Posted: Tue, 15 Jun 2004 @ 13:15:39 GMT
if you want to delete all rows of an table the bteq should be faster for the simple reason that you don't need the overhead of establishing the multiload. Teradata is recognising that it does not have to scan the table and just release the space (if you call something like delete from tab_A;) - in this case the bteq call will also not write a journal.
The main difference (in simple words) is that the Multiload Delete does not write into the journal tables and is therefore faster. You are not allowed to use PI delete statements in a Multiload Delete (where you have to qualify PI in a normal Multiload calling a delete statement). If you need to delete huge volumes from a table (but not all rows). Multiload Delete is quite good to do so.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|