Archives of the TeradataForum

Message Posted: Fri, 13 Apr 2007 @ 15:19:43 GMT

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

Dan - any secondary indices on the MultiLoaded tables?

Below is captured from a prior note from Dan Linstedt.

By the way, a note about performance on Teradata and getting data IN fast... I recently had the pleasure/opportunity to work on a large multi- node system, all I can say is MLOAD speeds were approaching 400,000 rows per second for 1.2k byte row sizes, to an empty table. FastLoad was approaching 600,000 rows per second to the same table.

Rgrds,

Bill Gregg
Teradata Team
Thomson Healthcare

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