RE: Question about Append hint in Insert

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Mon, 21 Jun 2004 19:27:40 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNGELOCEAA.lex.de.haan@naturaljoin.nl>

yes, there are:
for example, if you have a UNIQUE constraint with an underlying non-unique index,
you can disable the constraint without the need to drop the index; this provides some additional flexibility. and obviously, you *need* a non-unique index
in case you want the constraint to be deferrable. I am sure others on this list can provide more examples of subtle differences...

Kind regards,
Lex.

visit my website at http://www.naturaljoin.nl

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of jaromir nemec Sent: Monday, June 21, 2004 16:42
To: oracle-l_at_freelists.org
Subject: RE: Question about Append hint in Insert

Hi Lex,

Thanks for the correction of my misinterpretation. Does it mean there are no other differences or things to keep in mind when deciding between unique and non-unique index to support unique constraint?

Thanks
Jaromir D.B.Nemec

> one small correction: non-unique indexes do *not* allocate more space...

Binary/unsupported file stripped by Ecartis --
Type: text/x-vcard
File: Lex de Haan.vcf

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 Mon Jun 21 2004 - 12:24:31 CDT