Re: disabling foreign keys

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Wed, 16 Feb 2011 16:13:54 +0800
Message-ID: <AANLkTik_2r6orJYWS=RbnoSdwkc=ySbq+8v3kAbadoTU_at_mail.gmail.com>

Are they deliberately left disabled after the loading OR is it inadvertent?

Hemant K Chitale

sent from my smartphone
On 16 Feb 2011 07:17, "Clay Colburn" <clay.colburn_at_gmail.com> wrote:
> I have a database that is a data warehouse, so we bulk load data daily and
> tune the database for heavy read operations. I noticed that all of the
> foreign keys in the database are disabled. This obviously aids in the
speed
> of the loading process and the relationships can be verified during the
ETL
> process.
>
> My question is, are there any benefits to having these disabled
constraints
> laying around beyond just having a sort of meta-data description of the
> foreign key relationships? Does the optimizer use these at all?
>
> Thanks!

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

Received on Wed Feb 16 2011 - 02:13:54 CST