Re: possible to use an exceptions table in parallel?
Date: Tue, 24 Jun 2008 14:10:51 +0100
The old rule still applies. In case of indexes, see if Richard Foote has written anything first :)
I've linked to that page as it contains the links to all 3 of his original posts. There are some minor (or in some cases not so minor) differences between the two. It probably says something about deferrable constraint use that they first got approximately a decade ago and they still get forgotten (and sometimes surprise people).
On Tue, Jun 24, 2008 at 1:48 PM, Mark W. Farnham <mwf_at_rsiz.com> wrote:
> I haven't had a chance to test whether a unique or primary key constraint
> enforced by a non-unique index performs differently from one enforced by an
> index created as unique, so I've always been reticent to suggest it. Has
> anyone else tested this thoroughly?
> Niall Litchfield
> Oracle DBA