What is the difference between Multiload & Fastload interms of Performance?

Showing Answers 1 - 7 of 7 Answers


  • Sep 27th, 2006

Fast Load: to load empty tables at high speed.

MLoad: to insert,update and delete up to 5 different tables or views.


  • Dec 7th, 2007

If you want to load, empty table then you use the fastload, so it will very usefull than the mutiload..because fastload performs the loading of the data in 2phase..and it noneed a work table for loading the data.., so it is faster as well as it follows the below steps to load the data in the table

Phase1-It moves all the records to all the AMP first without any hashing 
Phase2-After giving endloading command, Amp will hashes the record and send it to the appropriate AMPS .


It does the loading in the 5 phases
Phase1:It will get the import file and checks the script
Phase2:It reads the record from the base table and store in the work table
Phase3:In this Application phase it locks the table header
Phase4:In the DML opreation will done in the tables
Phase 5: In this table locks will be released and work tables will be dropped.

  Was this answer useful?  Yes


  • Feb 15th, 2008

As the name suggests Fasload is faster than multiload, and whenever required to load an empty table fastload should be preferred.
However, Fastload has some limitations.

To perform Fload:
1. Target table must be empty
2. Fload performs inserts only (no updates)
3. Only one target table at a time
4. Must drop secondary indexes before loading and recreate them afterward

Multiload allows nonunique secondary indexes - automatically rebuilds them after loading


  Was this answer useful?  Yes

Aryan R

  • Oct 26th, 2010

1) Loads one table at a time
2) It does not load duplicate data.
3) Table should be empty.
4) Runs 2 phases.
5) It does not run in modes.
a) Import mode.
b) Delete mode.
6) It needs 2 error tables.
7) It does not support NUSI table
8) It applies Access lock on target Table during loading.

1) Loads up to 5 tables at a time.
2) Does not mind loading duplicate data.
3) Loads the data into the Table whether it can be either empty or full.
4) Runs 5 phases.
5) It runs in 2 modes.
6) It needs 2 error tables, 1 restart log table and 1 work table.
7) It supports NUSI table loading loading.
8) It applies write lock on target Table table during loading.

  Was this answer useful?  Yes


  • Jun 15th, 2015

how to resolve no more spool space issue?

  Was this answer useful?  Yes


  • May 22nd, 2016

What is Performance issues we considered while Execute the large amount data(Load the data from Files to Teradata Database)

  Was this answer useful?  Yes


  • Jun 8th, 2017

If you are looking at high volume data in that case Fastload would give better performance. since Fastload would work in 2 phases whereas Multiload will have 5 for the same. But we are looking at low volume data then you have TPump as another option.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions