primary keys and clustered indexes | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

primary keys and clustered indexes

Hi I am designing a database to store multiple clients information i.e. they will never see each others data. I have given all my clients a unique int in a client table in a different database. All my tables will have the ClientID field. So if my other tables have a primary key e.g. PropertyID it is by default clustered. Is it better to make it not clustered and have a clustered index as both the PropertyID and ClientID field as a client will only be accessing his/her data? cheers, mouse
Yes, since this would be the key that would be queried