Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Unique Constraint vs Unique Index

Unique Constraint vs Unique Index

From: Lyx <lynux_at_netvigator.com>
Date: 5 Jun 1999 18:55:44 GMT
Message-ID: <7jbrrg$5fo$1@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 Sat Jun 05 1999 - 13:55:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US