Guidelines for Other Batch Operations
When updating, exporting, or doing other batch operations, use the guidelines in the following table to consider the best choice for your job.
|
Task |
First Choice |
Second Choice |
|
Merging a large number of rows when logged on session are near their full capacity |
INSERT…SELECT or MERGE |
Tpump |
|
Merging a large number of rows when the specific order of updates is important |
Tpump |
INSERT…SELECT or MERGE |
|
Export a small number of rows from any table |
BTEQ |
FastExport |
|
Export a moderate or large number of rows from a large table |
FastExport |
BTEQ |
|
Update a small number of rows in any table |
TPump |
BTEQ |
|
Update a large number of rows in a large table |
MultiLoad |
BTEQ insert table into a new one. |
|
Perform multiple DML (INSERT, UPDATE, DELETE) operations on a small number of rows on multiple tables |
MultiLoad or TPump when the transaction density is too low for satisfactory performance |
BTEQ |
|
Perform multiple DML (INSERT, UPDATE, DELETE) operations on a large number of rows on multiple tables |
MultiLoad |
TPump |
|
Copy one or several tables to a different Teradata Database |
ARC |
FastExport and FastLoad |
|
Copy all tables in the Teradata Database system to a different Teradata Database system |
ARC |
|
|
Load an identity column table |
TPump (in ROBUST mode) |
BTEQ .IMPORT |
|
Load the data into staging table |
Teradata PT Load Operator |
Teradata PT Update Operator |