Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: IDs datatypes for schema design
From:   David Roth


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
Senior Consultant
NCR / Teradata Solutions Group

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023