Re: Design question re: DW data load

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: tboss@xxxxxxxxxxxxxxxxxx
  • Date: Wed, 26 Jan 2005 10:56:00 -0800

On Wed, 26 Jan 2005 10:43:40 -0500 (EST), tboss@xxxxxxxxxxxxxxxxxx 
> 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

Other related posts: