Re: Deferred contraints - DDL
Date: Wed, 10 Jun 2009 08:44:21 +0100
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.
-- jeremyReceived on Wed Jun 10 2009 - 02:44:21 CDT