Re: Design question re: DW data load

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 26 Jan 2005 10:56:00 -0800
Message-ID: <bf463805012610563b8c5b72@mail.gmail.com>

On Wed, 26 Jan 2005 10:43:40 -0500 (EST), tboss_at_bossconsulting.com ...
> but I wonder if you're eventually going to run into major performance
> issues w/ the disable/reenable of FK constraints. My guess is, once you
> get into the 100s of millions of rows, just re-enabling your FK constraints
> will blow out your maintenance window. This is what we've noticed; it takes
> hours to re-enable/create FK constraints on large tables. --

Have you tried 'enable novalidate'?

In a DW or any other environment where the data is scrubbed before loading there's probably no need to have the database validate the keys.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 26 2005 - 13:58:29 CST