Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: diff. between Primary-Key and unique index
In article <ErWh4.81$7R.1018_at_news.colt.net>,
"Bob Bain" <bob.bain_at_terra-nova.e-mail.com> wrote:
> Where is it documented that unique indexes shouldn't
> be used anymore, or is this just an Urban Legend that's
> floating around??
The documentation discouraged explicit unique indexes from 7.0 up to 8.0, but as of 8.1 they're encouraged again. They should have been encouraged all along. Depending on unique indexes to be created as a side effect of creating constraint is unreliable because the side effects of creating constraints can change from version to version.
Foreign keys can reference unique and primary keys, but they can't reference unique indexes.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Jan 24 2000 - 19:31:47 CST
![]() |
![]() |