Re: Oracle 8i - Materialized Views

Not that I have looked into it but my suspicion on b) is that to get this type of performance increase the 'Materialize' must mean 'Written Somewhere'. If this is the case the big downside would be on DML (or update) activity on the base tables leading to update activity somewhere else.

Only guessing though.

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. <dbhals_at_my-dejanews.com> wrote in message news:7hhag1$5qa$1_at_nnrp1.deja.com...
> I'm currently working on a DW project using
> Oracle 8i. One aspect which I'm looking at is
> Materialized views.
>
> My questions are:
> a) has anyone used MV in a DW or any other env.
> b) What are the pit falls (if any)
>
> Thanks in advance.
>
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
Received on Fri May 14 1999 - 11:37:24 CDT