16.10 - Guidelines for Inserting Rows - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

The following table provides some guidelines you can use to make the best choice of utilities when inserting rows. Keep in mind that you may find a better way through experimenting.

Task First Choice Second Choice
Insert a small number of rows into an empty table FastLoad TPump/BTEQ
Insert a large number of rows into an empty table FastLoad TPump
Insert a small number of rows into a small populated table BTEQ, MultiLoad, TPump or MERGE when the transaction density is too low for satisfactory performance  
Insert a small number of rows into a large populated table TPump, BTEQ, or MERGE  
Insert a moderate number of rows into a large populated table MultiLoad or MERGE TPump when the transaction density is too low for satisfactory performance
Insert a large number of rows into a large populated table MultiLoad or MERGE
  1. FastLoad rows into an empty table.
  2. INSERT...SELECT rows into an empty new table.
Insert a large number of rows into multiple populated tables MultiLoad TPump
Insert a large number of rows when logged on session are near their full capacity INSERT…SELECT or MERGE TPump
Insert a large number of rows when the specific order of updates is important Tpump INSERT…SELECT or MERGE
Insert a large number of rows into multiple empty tables Multiple FastLoads MultiLoad