Archives of the TeradataForum

Message Posted: Thu, 11 May 2006 @ 09:36:33 GMT

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

<-- Anonymously Posted: Thursday, May 11, 2006 05:25 -->

Hi,

SET/ MULTISET helps to keep the uniqueness of the complete record set, not the Index column.

As you depicted, definition of SET/ MULTISET for a table with UPI is REDUNDANT, (UPI checks for uniqueness and hence record set has to be different, ie SET)

but SET/ MULTISET definition is useful when you have NUPI.

SET with NUPI & MULTISET with NUPI is surely different.

Did this address the question ?

Thx

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