Archives of the TeradataForum
Message Posted: Thu, 18 Jan 2001 @ 13:55:36 GMT
This numeric primary key (and system assigned key) concept is pervasive in the industry with certain tool/rdbms vendors, especially relating to dimensional and star schema modeling (Kimball).
This really drives to physical implementation to support less perfomant databases. Since Teradata does not have this performance problem joining tables using real data, NCR's recommendation is always to use true business data for your primary keys and indexes, hence the recommendation to use varchar.
David W. Roth
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|