Re: Biuld my first Materialized View ever

C Chang wrote:

> Our 8.1.6 DB is on NT 4 with 2 CPU and 6x8 G HD on RAID. I like to
> build a Materialized View for Reporting purpose. So generally, for
> better performance, the materialized View is built on the current DB
> schema or another schema for this? Can anyone share their experience?
> The Materialized View that I design is REFRESH once a day in the 2 AM.
> It will collect almost half of the records of the current DB, roughly
> 400 MB. This is the first Materialized View I EVER do.
>
> C Chang

Based on what you have stated I would expect no negative consequences. And, quite possibly, better performance.

Daniel Morgan Received on Fri Mar 21 2003 - 10:22:06 CST