Archives of the TeradataForum

Message Posted: Mon, 17 Apr 2006 @ 14:37:27 GMT

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

If Fastload did secondary index builds you would have to call it: Half-fast load. It was designed to load FAST.

Mload will do NUSI's because they are on the same AMP as the data, will not talk to another AMP - therefore, no USI. Of course, it will be slower if you choose to do this.

This goes back to understanding the basics of how Teradata works and single AMP operations.

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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