Frank van Bortel wrote:
> Mark C. Stock wrote:
>
>> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
>> news:1076170588.168313_at_yasure...
>> | hrishy wrote:
>> |
>> | > Hi Daniel
>> | >
>> | > Can you please exaplin me why..that i should prefer unique
>> constraints
>> | > over unique indexes.
>> | >
>> | > regards
>> | > Hrishy
>> |
>> | Can't defer unique index ... can defer unique constraint
>>
>> excellent point -- it's interesting how often the ability to defer
>> constraints makes coding much, much simpler
>>
>> -- mcs
>>
>>
>>
>
> And almost a must-have when doing updatable replication, I'd like to add
Personally I think Oracle should either drop unique indexes or make
unique indexes and unique constraints two different syntaxes for
performing the exact same action. I've yet to find any justification for
unique indexes as implemented by Oracle.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sun Feb 08 2004 - 14:11:15 CST
