Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unique Constraint vs Unique Index
I'm not sure where you were looking, but both the 7.3.3 and the 8.0.5
documentation cdroms include the create unique index syntax.
Oracle recommends the constraint approach. They say that the uniqueness requirement is properly considered an attribute of the table. In today's versions, Oracle then uses an index to enforce the unique constraint. Fututre technology (I have no idea what) may develope a better way than an index to enforce uniqueness.
GDN wrote:
> When you take a look at the SQL-reference for Oracle 7, you see that the
> "create unique index... " statements doesn't exist any more. You can
> consider it as a hidden feature.
> So, you cannot be sure that it will work in future version of Oracle.
>
> GDN
>
> Lyx <lynux_at_netvigator.com> wrote in article
> <7jbrrg$5fo$1_at_imsp009a.netvigator.com>...
> > I am a newbie and determining on which methods (unique constraint or
> > unique index) would be better for a Data WH design.
> > Should there be any difference between a unique constraint or purely
> > unique index applied except for enabling/disabling constraint?
> > Also, what will be the internal engine done if a constraint is applied?
> >
> > Thanks!
> >
Received on Sun Jun 06 1999 - 14:52:52 CDT