 |
 |
Archives of the TeradataForum
Message Posted: Thu, 11 Dec 2008 @ 15:54:53 GMT
| Subj: | | Re: Rank and Delete? |
| |
| From: | | Geoffrey Rommel |
| | The manual provides information on differences in DELETE statements in the so called "Import Tasks" and "Delete Tasks". The latter are
less restrictive in their syntax, for example, but they would imply a full table scan and you are probably not much better off performance-wise
than with BTEQ. | |
Sorry to disagree with you, Victor, but MultiLoad Delete is faster than an ordinary SQL delete. It apparently uses a different algorithm to
handle the blocks. I once deleted a billion rows in about 15 minutes (intentionally :-) ).
| |
