Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unique Constraint vs Unique Index
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 - 05:04:42 CDT