>>For the Financial table, leave the Clustered index on the the PK.
>
>Are you sure about this? In the Financial table, the PK is FinancialID (surrogate integer), while the foreign key is CompanyID (surrogate integer). I perform calculations throughout the day on a set of Financial records for a given company. Shouldn't the clustered index be on CompanyID so that all of a company's financial records are grouped together?
Whoops. Someone was talking to me as I wrote this. I meant
FKSorry.
-Mike