RE: pros and cons

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 30 Mar 2004 19:41:45 -0500
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CFECFC6F@bosmail00.bos.il.pqe>

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.)

-Mark

-----Original Message-----

From:	Sai Selvaganesan [mailto:ssaisundar_at_sbcglobal.net]
Sent:	Tue 3/30/2004 5:50 PM
To:	oracle-l_at_freelists.org
Cc:	
Subject:	pros and cons

i read the follwing line in oracle 9i documentation,

Unique and primary keys can use non-unique as well as unique indexes. They can even use just the first few columns of non-unique indexes.

i am planning to use a primary key constraint enforced by the first few columns of a non-unique index.any feedback or advice or gotchas in having such a setup.

thanks
sai

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
-----------------------------------------------------------------



application/ms-tnef attachment: winmail.dat

Received on Tue Mar 30 2004 - 18:38:42 CST