|
Archives of the TeradataForumMessage Posted: Thu, 11 May 2006 @ 16:56:33 GMT
As I understand it, the primary index of a PPI table can only be unique if and only if the partition expression is part of the primary index (PI). If you partition on a field that is not part of the PI, even it the PI in the non-partitioned table is unique then you must define the new PI as a NUPI in the partitioned table.
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||