Archives of the TeradataForum

Message Posted: Thu, 28 Apr 2011 @ 21:00:12 GMT

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

<-- Anonymously Posted: Thursday, April 28, 2011 06:59 -->

HI All,

I read from TD MultiLoad reference manual that "Verify that the primary index is unique. NUPIs can cause severe MultiLoad performance problems"

I wonder if this applies for Multiset tables as well?. As per my understanding, multiset table will not check for row duplicates and hence faster(over set table) and also if we have NUPI on top of multiset, it will skip PI duplicate check and hence a Multiset table with NUPI should be the fastest option we have in TD.

Can someone correct me if I am wrong

Thanks

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