Re: Unique contraints vs. Unique indexes

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 14 Aug 2001 20:18:29 +1000
Message-ID: <3b78fa2d@usenet.per.paradox.net.au>

I'm not sure I'm a heavy hitter (I only weigh 70Kg), but here goes for nothing:

Personally, I think you'd be utterly mad NOT to create them deferrable. If those constraints are enforced with a unique index, then the index is dropped the second you disable the constraint, and thus will need complete re-creation.

Now dropping the index might be precisely what you need to have happen -but I rather prefer to have say in such matters, rather than have a huge index disappear without so much as a by your leave.

Of course, it then means you have to *remember* to drop the index when you need it to be dropped. But who said being a DBA was a walk in the park?!

Regards
HJR "James Williams" <techsup_at_mindspring.com> wrote in message news:3b744034.170930734_at_nntp.mindspring.com...
> I am about to build a data warehouse that will eventually be 1 TB.
>
>
> A PK's are going to have non_unique indexes and so that they can be
> deferrable.
>
>
> What are the heavy hitters opinions on this?
Received on Tue Aug 14 2001 - 05:18:29 CDT