Re: PK vs Unique index

From: Keith Boulton <kboulton_at_ntlworld.com>
Date: Thu, 17 Jan 2002 00:37:23 -0000
Message-ID: <8Zo18.31343$Hg7.3185212@news11-gui.server.ntli.net>

Dirk Gomez <> wrote in message news:m31ygqhxag.fsf_at_colorado.arsdigita.de...
> > A primary key is much more then a unique index (doesn't even have to use
a
> > unique index actually)...
>
> Could you explain this in a little more detail please?

From memory:

A primary key constraint can use a pre-existing non-unique index to enforce the constraint. This can offer significant performance advantages as you can enable/disable the constraint without having to rebuild the index.

Doing this screws up import/export I believe. Received on Wed Jan 16 2002 - 18:37:23 CST