RE: Question about Append hint in Insert
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 Jun 2004 19:27:40 +0200
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of jaromir nemec
Sent: Monday, June 21, 2004 16:42
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
