Xref: alice comp.databases.oracle.server:52189 Path: alice!news-feed.fnsi.net!netnews.com!newspeer.monmouth.com!skynet.be!poster!not-for-mail From: "GDN" Newsgroups: comp.databases.oracle.server Subject: Re: Unique Constraint vs Unique Index Date: 6 Jun 1999 10:04:42 GMT Organization: DE NEVE GERT Lines: 17 Message-ID: <01beb003$0b1a0e40$8909eec3@default> References: <7jbrrg$5fo$1@imsp009a.netvigator.com> X-Trace: news1.skynet.be 928663482 32125 195.238.9.137 (6 Jun 1999 10:04:42 GMT) X-Complaints-To: abuse@skynet.be NNTP-Posting-Date: 6 Jun 1999 10:04:42 GMT X-Newsreader: Microsoft Internet News 4.70.1155 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 wrote in article <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! >