Please ignore my last e-mail.=20 -----Original Message----- Jacques Kilchoer Would the FKs in a data warehouse do any harm? I imagine that they would come in handy for your new DBA to do an entity relationship diagram.=3D20 -----Original Message----- Tim Gorman Why are you using foreign keys in a data warehouse anyway? The only technical reason for FKs in a DW is when one is trying to use materialized view query-rewrite and one is utilizing QUERY_REWRITE_INTEGRITY =3D3D ENFORCED to prevent MV "staleness". Otherwise, there is no =3D technical reason for FKs, as there is no need for RI to be enforced in the DW, because the DW is not the source-of-record for the data. Validation reporting is much more effective than enforced constraints. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------