Per my research the ideal clustered index should be a narrow column and unique. We are currently on SQL Server 2012 and have a database setup for merge replication. I am in the process of adding a new table, StoreOPenDocuments, to our database. I am unsure what the clustered index should be.
Table StoreOpenDocuments
StoreOpenDocumentsID defined as UniqueIdentifier
CustomerID defined as UniqueIdentifier
InvoiceNumber
GrossAmount
.
Table MemberShipList (existing table)
MemberShipListID UniqueIdentifier
CustomerID UniqueIdentifier
StoreName
StoreAddressLine1
.
Would it make sense to make the StoreOpendocuments.CustomerID the clustered index even though it is not unique and is done on a UniqueIdentifier column?
Majority of our select statements will have where CustomerID = XXX
Or should I have the StoreOpenDocumetnsID be the clustered index, at least it is unique.
Thank you in advance for your time,
Tsharp89