Archives of the TeradataForum

Message Posted: Thu, 18 Jan 2001 @ 13:55:36 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Leszek,

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.

Regards,

Dave

David W. Roth
Senior Consultant
NCR / Teradata Solutions Group

	<Prev	Next>		<<First	<Prev	Next>	Last>>