Re: Unique and non unique index

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 15 Mar 2006 06:32:24 -0500
Message-ID: <f6udnRS8lo_WZorZnZ2dnUVZ_smdnZ2d@comcast.com>

"Rama Shankar" <ramashankar.yadav_at_gmail.com> wrote in message news:1142405431.617725.298530_at_i40g2000cwc.googlegroups.com...
: Hi All,
: We can enforce primary key constraint by using both unique
: and non-unique index. I want to know when to use unique index and when
: non unique.
:
: Thanks in advance.
:
:
: Regards
: Rama
:

oracle will use a pre-existing non-unique to enforce a primary key constraint

this allows the constraint to be (temporarily) disabled, or to be deferred, without dropping the index

++ mcs Received on Wed Mar 15 2006 - 05:32:24 CST