Archives of the TeradataForum
Message Posted: Tue, 09 Jan 2007 @ 13:38:45 GMT
The "uniqueness" check on a SET table is done by comparing all the bytes in all the fields.
The "uniqueness" check via a UPI is limited to the fields in the index.
Therefore, a set table with a non-unique primary index will allow the duplication of the primary index, provided that all the remaining fields also do not exactly match an existing row
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|