-
October 14th, 2019, 11:49 PM
#1
Using GUID as Primary Key
Can we use a GUID column as a primary key in a table?
-
October 15th, 2019, 01:46 AM
#2
Re: Using GUID as Primary Key
Victor Nijegorodov
-
October 18th, 2019, 04:20 AM
#3
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/
-
October 19th, 2019, 04:59 PM
#4
Re: Using GUID as Primary Key
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|