Forum guidelines
AuthorQuestion
What is the size of a GUID?
Posted on: 19 Nov 2012
What is the size of a GUID?
Vithal Wadje
AuthorReply
Re: What is the size of a GUID?
Posted on: 19 Nov 2012  
128 bits or 16 bytes.
Re: What is the size of a GUID?
Posted on: 20 Nov 2012  


For a table GUID uses for primary key and when we use it as a primary key so it creates a clustered index on that table. When we use GUID as clustered index then it decreases performance for inserting new data.

because there is 16 bytes binary data which is logically grouped by "-" sign.

for example

    12345678-1234-1234-1234-1234567890EF
    4bytes   2bytes 2bytes 2bytes 6bytes 

So its size 4+2+2+2+6 = 16bytes

on twitter @ss_shekhawat

SPONSORED BY

Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.