 |
 |
Archives of the TeradataForum
Message Posted: Wed, 06 Jul 2005 @ 19:01:39 GMT
| Subj: | | Re: Partitions and indexes |
| |
| From: | | Anantaraman, Kumaran (K.) |
Anonym wrote :
| | 1. Why is it that a unique primary index cannot be defined if the partitioning column is not included as a part of the PI? I want to
understand the "theory" behind this!! | |
How about this?
TD has to check for duplicate UPIs when inserting rows. If partition does not include all UPI columns, then TD may have to search IN ALL
partitions for existing rows with same UPI values that may conflict with new incoming row.
Kumaran Anantaraman
| |
