Re: Deferred contraints - DDL

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

In article <pcqdnSdTKroYX7PXnZ2dnUVZ8uqdnZ2d_at_bt.com>, jonathan_at_jlcomp.demon.co.uk 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.

-- 
jeremy

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