Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 10 Mar 2005 @ 18:58:36 GMT

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

Subj:   Re: Restrict number of Rows Affected
From:   Kohut, Eric J

If the delete is as basic as you stated with:

no joins (sub queries included) or PI value restriction

I would use the MLOAD Delete option of Multiload.

It doesn't require input of any data just an SQL with the restriction on some column to qualify the delete. It does not require a journal or a commit, since Multiload keeps a logtable of where it left off. It is restartable and very, very fast.

It supports basic SQL except above restrictions.

Eric J. Kohut
Senior Solutions Consultant - Teradata Benchmark Group
Certified Teradata Master
NCR Corp.

  <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: 28 Jun 2020