Re: Disabling Existing Constraints and Index dropped

From: Anurag <avdbi_at_hotmail.com>
Date: Tue, 6 Aug 2002 02:32:43 -0400
Message-ID: <ukurccfefnbuf0@corp.supernews.com>

Add to the above post ..
if you create an index deferrable, Oracle enforces it using a non-unique index, which is not dropped if you disable the PK constraint.

Search this newsgroup and you'll find excellent threads related to this.

Anurag

"srivenu" <srivenu_at_hotmail.com> wrote in message news:1a68177.0208052014.6551bed8_at_posting.google.com...
> Yes the index will be created again if you enable the constraint.
> If you are doing this very frequently, it may result in performance
> problem.
> So create a non-unique index explicitly on the primary key columns and
> then add the constraint.
> A non-unique index will not be dropped even if you disable the
> constraint.
Received on Tue Aug 06 2002 - 01:32:43 CDT