 |
 |
Archives of the TeradataForum
Message Posted: Wed, 28 Oct 2009 @ 20:26:45 GMT
| Subj: | | Re: Delete duplicate rows from a MULTISET table |
| |
| From: | | frank.c.martinez |
The best? An insert/select into the same structure but as a SET table. The duplicate records will encounter a Boojum (they will "softly and
suddenly vanish away") in what I vaguely remember being called a "silent drop" or something like that. Drop the original MULTISET table or rename
it to something obnoxious. Use it only to speed up loading. Rename your good and wonderful SET table to the original name. Forget you ever knew
anything about MULTISET, except when trying to do the aforementioned load speed-up. Live long and prosper.
iv
| |
