Archives of the TeradataForum
Message Posted: Sat, 08 Mar 2003 @ 09:58:53 GMT
Anomy Anom wrote:
Do you delete using SQL? In the case of a failure this will result in a very long rollback.
A MultiLoad DELETE job is faster than SQL, because there's no transient journal and there's never a rollback.
Or you export the data to be deleted (including the PI columns) and use a Mload IMPORT job to delete the rows. You could even add that to the existing Mload job, so it will be done using a single Table Scan.
Another way is to insert/select the rows not to be deleted into a new table. This maybe the fastest way, but only if it's deleting much more than 2.5%.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|