Archives of the TeradataForum
Message Posted: Mon, 11 Feb 2002 @ 22:32:59 GMT
| Subj: || || Re: Insert data into table |
| From: || || Buckland |
The big reason that some people choose Multiset over Set tables is for load time, especially with MultiLoad. If the table being loaded
has a lot of duplicates on the Non Unique Primary Index then the duplicate row checking can take a long time, even if there are no
duplicates in the full row. Redefining the table to Multiset does away with the duplicate checking. I once saw the monthly load time on a
table with lots of NUPI dups go from 18 hours to 40 minutes once this change was made.
So it can be of use even if Mr Codd is still honored.