Archives of the TeradataForum
Message 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: 28 Jun 2020|