Re: Deferred contraints - DDL

From: Jeremy <>
Date: Wed, 10 Jun 2009 08:44:21 +0100
Message-ID: <MPG.2499739eedd17e9a98972f_at_News.Individual.NET>

In article <>, says...

> Don't make unique/primary key constraints deferrable unless
> you have a good reason to. They have to be supported by
> non-unique indexes, and this affects the costing (so plans may
> change), latch activity, and the volume of undo and redo.

Thanks for that info Jonathan.

Received on Wed Jun 10 2009 - 02:44:21 CDT

Original text of this message