Proper Indexing stategy
I have a table that has a surrogate key (means nothing) and then 4 additional columns that represent the unique record.
I was thinking I should do this:
Create a primary key on the surrogate key only.
Create a unique key on the 4 additional columns that make the unique record.
Queries will be querying the additional 4 columns, they will never query the surrogate key.
What is your opinion.
Read this before you decide on surrogate keys:
Conceptual Muddling and Database Kludges