Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unique Key
>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