Gints, There's another aspect to this conversation with regards to the fact that for warehouse implementations foreign key constraints are often times *enforced* in the ETL process and not in the database definition. Insofar as that's the case, the extra expense you describe in checking that foreign key relationships tie back to a parent record row isn't incurred. Rumpi -- //www.freelists.org/webpage/oracle-l