[SQL] Generic design: char vs varchar primary keys

Hi, Can you point me to any pages that explain the difference between using, say CHAR(8) vs VARCHAR(8) as the primary key for a table? Is there any impact on the database in terms of: - Speed of indexed retrieval - Speed of join from a referencing table - Storage (I presume VARHAR(8) would hav

Re: [SQL] Generic design: char vs varchar primary keys

2011/8/3 Raj Mathur (राज माथुर) : > Hi, > > Can you point me to any pages that explain the difference between using, > say CHAR(8) vs VARCHAR(8) as the primary key for a table?  Is there any > impact on the database in terms of: > > - Speed of indexed retrieval > - Speed of join from a referencing

Re: [SQL] Generic design: char vs varchar primary keys

On Thursday 04 Aug 2011, Josh Kupershmidt wrote: > 2011/8/3 Raj Mathur (राज माथुर) : > > Can you point me to any pages that explain the difference between > > using, say CHAR(8) vs VARCHAR(8) as the primary key for a table? > > Is there any impact on the database in terms of: > > > > - Speed of i