Archives of the TeradataForum
Message Posted: Fri, 15 Nov 2002 @ 16:50:25 GMT
It sounds to me like a dogma as the definition of a PI - unique or non-unique - does or should heavily depend on what you are going to do with the table. If you have to join in 90% of your questions with this field to an other table with the same PI the selection would be good. Without the knowledge of the remaining data model it is very hard to device.
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023