Archives of the TeradataForum

Message Posted: Mon, 10 Aug 2009 @ 15:22:57 GMT

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

Brian's statement is echoed at the bottom of page 59 of the Teradata Fastload Reference Manual [Release 12.00.00 - B035-2411-067A - July 2007], where, under the header "Nonunique Index Sorts" the following statement appears:

"If you define a Teradata Fastload table with a nonunique primary index, you can enhance the performance of the Teradata Fastload job by not using the index value to sort the input data."

Regards,

Terry
Terry M. McLeod T Senior Consultant Teradata

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