Archives of the TeradataForum
Message Posted: Thu, 28 Apr 2011 @ 21:00:12 GMT
<-- Anonymously Posted: Thursday, April 28, 2011 06:59 -->
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|