Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2003 @ 14:02:56 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>