Archives of the TeradataForum
Message Posted: Wed, 24 Jan 2001 @ 17:41:54 GMT
Anybody want to take a poll? My vote is leave it that way. I've used Multiset tables, as well as tables with duplicate rows in other databases. In order to change, delete or even read ONLY ONE of those rows, it requires:
A) Knowing the ^%&$&% rowid and working with rowid, or
B) Reading all the dups, deleting all of them and then either putting back all the "others" you want (the delete option) or updating the one you want and writing it and all it's brothers.
And all this for what? Because someone hasn't adequately defined the table, ultimately!
Ok, I'm done ranting.
Frank C. Martinez IV
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|