Archives of the TeradataForum

Message Posted: Tue, 09 Jan 2007 @ 10:20:35 GMT

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

<-- Anonymously Posted: Monday, January 08, 2007 23:46 -->

Hello All,

Just need clarification on SET and Unique Primary Index.

As far as I know

SET - Will not allow duplicate rows

MULTISET - Will allow duplicate rows.

If a table has UPI, there could not be any Duplicate rows at all.

I have a table which has UPI and SET option.

Will Teradata checks for duplicate rows twice( as part of SET and UPI ) while insertion.

Please correct me if I am wrong.

Thanks,

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