Archives of the TeradataForum

Message Posted: Tue, 29 Nov 2005 @ 17:56:46 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- 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

Thanks,

Anonym

	<Prev	Next>		<<First	<Prev	Next>	Last>>