Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PK vs Unique index
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