Archives of the TeradataForum
Message Posted: Tue, 29 May 2001 @ 12:10:21 GMT
When performing a MultiLoad to two tables at the same time, is there any difference in performance, resource utilisation, data being sent between IBM and Teradata etc when using:
- One DML LABEL with two INSERT statements to the two target tables, and one corresponding APPLY statement ...or...
- Two DML LABELs with one INSERT statement each and two corresponding APPLY statements.
The data to be loaded will have rows that go into each table, so there is no logic to be performed in the APPLY-statements.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|