 |
 |
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.
Walt Craig
Baseline Consulting Group, Inc.
| |
