disabling foreign keys
- From: Clay Colburn <clay.colburn@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 15 Feb 2011 15:16:00 -0800
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!
Other related posts:
