Archives of the TeradataForum

Message Posted: Tue, 31 Jan 2006 @ 20:26:48 GMT

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

<-- Anonymously Posted: Tuesday, January 31, 2006 15:23 -->

I have a simple performance question on this topic.

Which will Selects, Inserts, Updates, and Deletes perform better on ?

1) A SET table with a UPI

Or

2) A MULTISET table with a UPI

The UPI will keeps duplicate rows out.

Thanks.

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