If they are disabled, no, the optimizer can not use them. Other tools may use the metadata and even if they are in a disabled state (ERD tools etc) which may be desirable. On Tue, Feb 15, 2011 at 3:16 PM, Clay Colburn <clay.colburn@xxxxxxxxx> 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! -- Regards, Greg Rahn http://structureddata.org -- //www.freelists.org/webpage/oracle-l