467,075 Members | 1,070 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,075 developers. It's quick & easy.

Guid as primary key

When using a Guid as your primary key in a table, does it make
sense to make it a clustered index?

Thanks,
Rick
Jul 20 '05 #1
  • viewed: 3061
Share:
1 Reply
Depends on how the table is used. But if you do and if you are retrieving
many records at a time by PK and there is a good chance that those records
were created at the same time (for example an order details table), you may
want to generate the GUIDs using the 'old' GUID generation function
UuidCreateSequential.

http://msdn.microsoft.com/library/de...sequential.asp
"Rick" <ri**@abasoftware.com> wrote in message
news:28**************************@posting.google.c om...
When using a Guid as your primary key in a table, does it make
sense to make it a clustered index?

Thanks,
Rick

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

24 posts views Thread by Ilija_G | last post: by
3 posts views Thread by Robert Chapman | last post: by
1 post views Thread by Leon | last post: by
4 posts views Thread by Grey | last post: by
12 posts views Thread by Geoff Jones | last post: by
14 posts views Thread by Roy | last post: by
8 posts views Thread by Leon_Amirreza | last post: by
1 post views Thread by Jeff | last post: by
4 posts views Thread by Marc | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.