Archives of the TeradataForum
Message Posted: Mon, 14 Feb 2005 @ 17:52:11 GMT
Subj: | | Re: Set table vs. Multiset table with Unique Primary index |
|
From: | | David Wellman |
There are lots of differences between these two.
A MULTISET table with a unique index (primary or otherwise) does not make sense to me. The Multiset says that you can store duplicate rows, but
the unique index then prevents duplicate rows.
A SET table with no unique indexes will force Teradata to check for duplicate rows every time a row is inserted or updated. This can cause a
lot of overhead on such operations.
What's driving this question ? Maybe with that we can you a mor specific answer.
|