Primary Key vs. UQ Index

From: Byron Pearce <bpearc1_at_abacus.tis.tandy.com>
Date: 21 Nov 1994 23:01:24 GMT
Message-ID: <3ar8s4$j02_at_abacus.tis.tandy.com>

Which is the more accepted method for enforcing a UNIQUE primary key: the use of the PRIMARY KEY constraint or the use of a UNIQUE index on the primary key field(s)? I can see pros and cons (such as being able to control extent size and spread i/o by placing the tables and indexes on different disks -- something you cannot do with a PRIMARY KEY). I thought that I would solicit the masses for personal experiences and/or horror stories on this issue.

Thanks for the assist!

---

Byron Pearce                        |  The thoughts and views herein do not
Tandy Information Services          |  necessarily reflect that of Tandy
byron.pearce_at_tandy.com              |  Corporation.
------------------------------------------------------------------------------

"It's hard to be a ninja when you wear a beeper."

---

Received on Tue Nov 22 1994 - 00:01:24 CET