|
Archives of the TeradataForumMessage Posted: Thu, 08 Mar 2012 @ 13:41:59 GMT
It is possible for NUPI (non-unique primary index). You can add a partitioning column that is not a part of the primary index. However for UPI (unique primary index), the partitioning column has to be a part of the key. This is so that the RDBMS only looks on the current target AMP to check for duplicates.
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||