Archives of the TeradataForum
Message Posted: Thu, 13 Mar 2003 @ 14:02:56 GMT
The fast path insert assumes that the target table is empty and that the DDL is precisely the same for the source and target tables. Then, it moves blocks rather than having to insert rows.
In addition, as the target table is empty, the transient journal is not required as the optimiser knows that the starting position is an empty table. This speeds it up considerably.
Hope this helps
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|