If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#28
|
|||
|
|||
Maybe it's cause they don't care?
-Amy wrote in message oups.com... BruceM wrote: To clarify, I am not going to use a multi-field PK when there are other (and simpler) means to guarantee uniqueness. If I have PartNumber and Process (plating, welding, etc.) it makes sense to combine the two, since the combination of Blade and Plating should appear just once. I'll try one last attempt at getting the message across. Use your multi-field PK to build the clustered index. The clustered index is for that table and that table alone. Use your simpler 'PartNumber and Process' in the FOREIGN KEY relationship. If it isn't already, constrain 'PartNumber and Process' with NOT NULL UNIQUE. Remember that you can have many NOT NULL UNIQUE constraints in a table but only one clustered index (=PK) It has a lot to do with reading what others have written here (people who offer a lot pragmatic and practical advice, and who have demonstrated again and again their command of the program) Ask yourself: do these other people recommend an autonumber as PRIMARY KEY in the knowledge that it creates a clustered index (physical ordering)? I've yet to hear anyone here say, 'Yes, autonumber makes for a fine clustered index.' |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sorting a table by concatenating several fields in the same table | salsaguy | Running & Setting Up Queries | 3 | March 6th, 2005 09:41 PM |
Sorting a table by concatenating several fields in the same table | salsaguy | Running & Setting Up Queries | 0 | March 6th, 2005 02:33 AM |
Additional fields for form based parameter query/null fields | geeksdoitbetter | Running & Setting Up Queries | 2 | January 7th, 2005 11:05 PM |
Selecting Fields for Update | Steve Daigler | Page Layout | 4 | October 15th, 2004 02:13 PM |
My tables lost their AutoNumber fields | Bill Nicholson | Database Design | 2 | July 2nd, 2004 02:20 AM |