Re: Unique Indexes VS. Constraints

sboucher_at_my-deja.com wrote:
>
> I'm curious, why would a database design use unqiue indexes versus
> constraints to enforce integrity.
>
> Situation: I have to determine how a large oracle db is put together.
> This database has some constraints but many more unqiue indexes as I
> determined using Oracle Enterprise Manager and ERWIN. I understand this
> DB's origin may have been from a flat DB2 database.
>
> Thanks
> Scott
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Most db's have unique indexes, whereas not all may have unique constraints...Thus 3rd party tools may choose to use the former to claim vendor independence I suppose...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse