RE: possible to use an exceptions table in parallel?
From: Yong Huang <yong321_at_yahoo.com>
Date: Wed, 25 Jun 2008 10:48:30 -0700 (PDT)
Message-ID: <763395.40625.qm@web80602.mail.mud.yahoo.com>
Date: Wed, 25 Jun 2008 10:48:30 -0700 (PDT)
Message-ID: <763395.40625.qm@web80602.mail.mud.yahoo.com>
> 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,
When you get ORA-1, there's a non-negligeble performance difference. See Eric
S. Emrick's article at
http://orafaq.com/papers/oracle_redo_generation_wp.pdf
Also,
http://groups.google.com/group/comp.databases.oracle.server/browse_frm/thread/c13d5d08f9ced6b9
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 25 2008 - 12:48:30 CDT