Sql Server: uniqueidentifier plus integer compound PK ... what type of index to use?
I have a junction table in my SQL Server 2005 database that consist of two columns:

 - object_id (uniqueidentifier)
   
 - property_id (integer)

These values together make a compound primary key.

**What's the best way to create this PK index for SELECT performance?**

If the columns were two integers, I would just use a compound clustered index (the default). However, I've heard bad things about clustered indexes when uniqueidentifiers are involved.

Anyone have experience with this situation?

Sql Server: uniqueidentifier plus integer compound PK ... what type of index to use?
===

I have a junction table in my SQL Server 2005 database that consist of two columns:

 - object_id (uniqueidentifier)
   
 - property_id (integer)

These values together make a compound primary key.

**What's the best way to create this PK index for SELECT performance?**

If the columns were two integers, I would just use a compound clustered index (the default). However, I've heard bad things about clustered indexes when uniqueidentifiers are involved.

Anyone have experience with this situation?
