17.00 - 17.05 - Guidelines for Other Batch Operations - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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 Vantage system ARC FastExport and FastLoad
Copy all tables in the Vantage system to a different Vantage 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