Archives of the TeradataForum
Message Posted: Tue, 29 Nov 2005 @ 17:56:46 GMT
<-- Anonymously Posted: Tuesday, November 29, 2005 11:25 -->
Can someone please point out the plus and cons of defining a table as MULTISET?
I personally do not like them and avoid them in my designs but we have an application that has one table with 3B rows and approximately 150 repeated values on each Primary Index value.
It voraciously consumes gobs of CPU inserting and updating less than 20M rows once a week.
Please share any good, bad, and ugly experiences you have encountered with multiset tables
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|