disabling foreign keys
From: Clay Colburn <clay.colburn_at_gmail.com>
Date: Tue, 15 Feb 2011 15:16:00 -0800
Message-ID: <AANLkTi=4aVcoWu59mgNs6UXmTJqucJxXGFs29fU=KWZ9_at_mail.gmail.com>
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.
Date: Tue, 15 Feb 2011 15:16:00 -0800
Message-ID: <AANLkTi=4aVcoWu59mgNs6UXmTJqucJxXGFs29fU=KWZ9_at_mail.gmail.com>
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-lReceived on Tue Feb 15 2011 - 17:16:00 CST