Re: pros and cons

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 31 Mar 2004 22:43:58 +1000
Message-ID: <0ebf01c4171d$d6467a50$0100000a@FOOTE>

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_at_il.proquest.com> To: <oracle-l_at_freelists.org>
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_at_freelists.org 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

---

Received on Wed Mar 31 2004 - 06:36:22 CST