Re: Primary Key vs. UQ Index

In article <3ar8s4$j02_at_abacus.tis.tandy.com>, bpearc1_at_abacus.tis.tandy.com (Byron Pearce) wrote:

> 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!
>

  I won't comment on the adv/disadv other that to say that my understanding is that

1. you can specify a table space for constraints with a UNIQUE TABLESPACE clause
2. UNIQUE clause of a CREATE INDEX statement will disappear in the future.

Regards,
Jodi.

> ==============================================================================
> 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 Fri Nov 25 1994 - 21:04:49 CET