 |
 |
Archives of the TeradataForum
Message Posted: Tue, 14 Jul 2015 @ 09:26:25 GMT
| Subj: | | Re: PPI in TD |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Tuesday, July 14, 2015 01:05 -->
Anomy.Anom wrote:
| | If the partitioning column is not part of the PPI, then enforcing PI uniqueness would be a very costly operation requiring a check for
duplicate PI values within each partition. | |
| | But if the partitioning column is part of the PI, then the uniqueness check is limited to a single RowHash just as it is for non-PPI
tables. | |
Why would a check for duplicate PI values be required in the first place. We are defining a UPI on the table and the values will be unique
anyway in the partitions.
| |
