 |
 |
Archives of the TeradataForum
Message Posted: Thu, 13 Mar 2003 @ 14:02:56 GMT
| Subj: | | Re: Fast Path Insert |
| |
| From: | | Frank O Connor |
Kumaran
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
Frank
| |
