Archives of the TeradataForum
Message Posted: Mon, 11 Feb 2002 @ 21:54:53 GMT
| Subj: || || Re: Insert data into table |
| From: || || Walt Craig |
Yes, it is true, any Unique index will preclude duplicate rows. Don't know why someone would recommend Multiset over Set except that
Teradata never allowed duplicate rows, whereas ANSI standard does. (Ted Codd would croak at the thought!) The Teradata default is Set and
I had a client whose data required that we accept duplicates so we had to change the table definitions to MULTISET. Hard for me to see
where that might be useful, but the client was happy having two or more rows with exactly the same data. Made sense when loading the data
from the source, but once it was loaded and cleaned those duplicate rows should no longer had any meaning.
Baseline Consulting Group, Inc.