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 -> Re: Unique Key

Re: Unique Key

From: Brian Peasland <peasland_at_email.msn.com>
Date: Tue, 27 Jul 1999 19:17:14 -0500
Message-ID: <#15aR6I2#GA.115@cpmsnbbsa02>


>It would advisable to create a unique constraint as opposed to a unique
>index. I saw some Oracle blurb a while ago that said Oracle may no
>longer support unique indexes as such in the future (although a unique
>constraint is implemented with a unique index anyway!)

When you create a unique constraint, Oracle automatically creates an index for you. That's the only way it can guarantee uniqueness without doing full table scans.

Brian Peasland
peasland_at_msn.com Received on Tue Jul 27 1999 - 19:17:14 CDT

Original text of this message

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