469,922 Members | 2,148 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,922 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
1 3145
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
reply views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.