Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unique contraints vs. Unique indexes
James Williams wrote:
>
> 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?
A non-unique index is less "attractive" to the optimiser than a unique one, but deferrable primary keys are very nice when removing duplicates (ie cleaning up your data)...
... I'd look at using deferrable constraints where you think they will be appropriate rather then as a rule.
hth
connor
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Mon Aug 13 2001 - 13:39:18 CDT