Guid as primary key

[Rick]

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

Thanks,
Rick

[screwed]

Re: Guid as primary key

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
UuidCreateSeque ntial.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rpc/rpc/uuidcreatesequential.asp

"Rick" <rick@abasoftwa re.com> wrote in message
news:28d7cbb9.0 404150848.78eac 7b4@posting.goo gle.com...[color=blue]
> When using a Guid as your primary key in a table, does it make
> sense to make it a clustered index?
>
> Thanks,
> Rick[/color]