472,141 Members | 1,295 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,141 software developers and data experts.

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 3213
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 leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.