RE: pros and cons
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 30 Mar 2004 19:41:45 -0500
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@xxxxxxxxxxxxx]
Sent: Tue 3/30/2004 5:50 PM
To: oracle-l@xxxxxxxxxxxxx
Cc:
Subject: pros and cons
hi
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
Other related posts:
