Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Bottom line: In some cases where there is no other suitable candidate for a primary key, create a new primary key which only use is to identify the record. As shown in the navision database this can be both a surrogate or intelligent key. In other cases where there is a suitable PK available (depends on the domain), use that one (Examples: Invoicenumber, ItemNo, CustomerNo) because it will make you life easier when building, maintaining and debugging your system and keeps performance to the max as it generally needs less joins in queries.
Thanks, Walter.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only