Archives of the TeradataForum

Message Posted: Tue, 11 Nov 2003 @ 15:11:42 GMT

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

Rachana

You have received many good suggestions already.

What you may need to check for also is the number of non-unique primary index values. If the primary index is a constant, all the data will be loaded to the same amp.

If the table is a set table, all rows with a given primary index value will be compared to the incoming row with that value. So, for the 100th row with a NUPI value of X, it will be compared with 99 others. The 101st will be compared to the previous 100 etc. Multiset will overcome this but you need to take care that you do not load that data twice.

I hope that helps

Frank

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