I have 2 tables
In both tables we have the column
Customer_id which should contain unique values.
Customerkpi is a foreign key of the
Customer_id of the table
Customer which is the primary key.
I need to create indexes on
customerkpi in the best way.
Should I create a primary key on
Customer_id and mentioned also the foreign key in this way it creates automatically a clustered index, or should I just declare it as a foreign key and then I create a cluster unique index on
which solution give the best performance?