 |
 |
Archives of the TeradataForum
Message Posted: Fri, 31 Dec 2010 @ 15:19:03 GMT
| Subj: | | Re: What is faster fastload or mload and why? |
| |
| From: | | Dieter Noeth |
DWellman wrote:
| | You'll probably find that Fastload is quicker, but you may not notice it at small volumes. | |
| | Why ? Because it does less work. FL loads data directly into the target table and then sorts it. ML loads it into a work table, sorts it
and then copies that into the target table. | |
In fact the Acquisition Phase of MLoad is the same as a FastLoad into the work table (i would bet it's using the same code internally), so
MLoad will always be slower, because there's the additional Application Phase.
Dieter
| |
