Re: pros and cons

From: "Richard Foote" <richard.foote@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 31 Mar 2004 22:43:58 +1000

Hi Mark,

The index doesn't have to be dropped if you use the KEEP INDEX option (9i).

Cheers

Richard

From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, March 31, 2004 10:41 AM
Subject: RE: pros and cons

No gotchas that I'm aware of.

I look at it as an adavantage, because when you're doing table maintenance,
you can disable the PK/UK constraint, and the corresponding index won't be
dropped.  In the case of a unique index, any time you diable the
corresponding constraint, the index will be dropped.  (It has to be, else
the column would still have the unique property, due to the index.)

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

References:

RE: pros and cons
From: Bobak, Mark

Re: pros and cons

Other related posts: