Re: Question regarding view

From: Anurag Varma <avoracle_at_gmail.com>
Date: 20 Apr 2006 10:12:25 -0700
Message-ID: <1145553145.860328.249400@z34g2000cwc.googlegroups.com>

<quote>

First of all if this is a data warehouse you don't need any primary keys. Referential integrity in the data, coming from your OLTP systems, should be assured and not DML should be taking place.

You may need constraints, or their indexes, for the optimizer to help it make good choices but that is quite another matter.
</quote>

Daniel,
You might want to qualify that. Referential Integrity relationships are needed in a data warehouse for star transformations, query rewrite etc.
Its another matter that one might have them disabled / no validated only if the data can be relied upon to be consistent.

Anurag Received on Thu Apr 20 2006 - 12:12:25 CDT