Generic design: char vs varchar primary keys
От
Raj Mathur (राज माथुर)
Тема
Generic design: char vs varchar primary keys
Дата
Msg-id
201108032040.17628.raju@linux-delhi.org
Список
Дерево обсуждения
Re: Generic design: char vs varchar primary keys Jasen Betts <jasen@xnet.co.nz>
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 have a slight edge, in general) - Any other issue Regards, -- Raj -- Raj Mathur raju@kandalaya.org http://kandalaya.org/ GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F PsyTrance & Chill: http://schizoid.in/ || It is the mind that moves
В списке pgsql-sql по дате отправления