Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Key
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00171828
Message ID:
00171992
Views:
31
>I suspect I don't fully understand their (surrogate keys) utility. I'll have
>to get one of the wunderkinder to explain it to me sometime.

Well, there are two main reasons. One is joins: a 4-byte integer key is a lot faster than, say, an 11-byte character SSN. The other reason is uniqueness: if you create a view on an order detail table, do you want to have to have the concept of order detail line number, so that you have a composite key (order + linenum), or just stick a 4-byte number at the beginning of each line? (not that this example really proves my point, but...)
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Reply
Map
View

Click here to load this message in the networking platform