Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 15 Jun 2004 @ 13:15:39 GMT

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

Subj:   Re: Mload delete and Bteq Delete
From:   ulrich arndt


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.


  <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