MATERIALIZED VIEW - Need Advice

From: <pankaj_wolfhunter_at_yahoo.co.in>
Date: 22 Jan 2007 03:26:35 -0800
Message-ID: <1169465195.652882.279340@38g2000cwa.googlegroups.com>

Greetings,

In our application, we have a several tables which gets loaded with millions of records per day
and we have to run reporting queries on these tables which involves lot of aggregations.
I just heard of materialized views.

For now our queries run on base tables.
I am thinking of suggesting the idea to go for MATERIALIZED VIEW which precomputes
the sum and increases the performance. Our is an totally Data-warehouse kinda application.

Just want to know the comments/suggestions from experts before suggesting this.

let me know if something else is required.

Any help would be appreciated.

TIA DB Version:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi PL/SQL Release 10.2.0.1.0 - Production Received on Mon Jan 22 2007 - 05:26:35 CST