Archives of the TeradataForum
Message Posted: Tue, 09 Jan 2007 @ 10:20:35 GMT
<-- Anonymously Posted: Monday, January 08, 2007 23:46 -->
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|