-
Proper Indexing stategy
All,
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.
Thanks,
Kathy
-
Hi Kathy,
Read this before you decide on surrogate keys:
Conceptual Muddling and Database Kludges
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|