Using GUID as Primary Key
Can we use a GUID column as a primary key in a table?
Re: Using GUID as Primary Key
Re: Using GUID as Primary Key
GUID can be used as a Primay key but it's having some drawbacks like :
(1) They are large(16 bytes) that is they will consume more space .
(2) Even performance and storage implications are present in this.
(3) They do not sort well as they are essentially random numbers.
(4) They are hard to remember as well as hard to debug.
(5) They can make URL's harder to read.
Do refer this link : https://blog.codinghorror.com/primar...-versus-guids/
Re: Using GUID as Primary Key
Quote:
Originally Posted by
Sherin Mathew
GUID can be used as a Primay key but it's having some drawbacks like :
(1) They are large(16 bytes) that is they will consume more space .
(2) Even performance and storage implications are present in this.
(3) They do not sort well as they are essentially random numbers.
(4) They are hard to remember as well as hard to debug.
(5) They can make URL's harder to read.
Do refer this link :
https://blog.codinghorror.com/primar...-versus-guids/
Dated info. Those are largely problems of the past, at least on newer versions of SQL Server anyway.