Anurag Varma wrote:
> <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
I thought that I said as much when I wrote: "You may need constraints,
or their indexes, for the optimizer."
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Apr 20 2006 - 13:38:41 CDT
