Re: possible to use an exceptions table in parallel?
Date: Tue, 24 Jun 2008 14:12:55 +0100
I hate touchpads!!!
I should have written "It probably says something about deferrable constraint use in the real world, that they first got introduced approximately a decade ago and they still get forgotten (and sometimes surprise people)"
On Tue, Jun 24, 2008 at 2:10 PM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:
> The old rule still applies. In case of indexes, see if Richard Foote has
> written anything first :)
> http://richardfoote.wordpress.com/2008/06/04/primary-keys-and-non-unique-indexes-whats-really-happening/ -
> 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
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 24 2008 - 08:12:55 CDT