Re: PeopleSoft DBA Forum Materialized Views
- In normal view, base query is just stored in the Oracle data
dictionary. Every time you query a normal view, it looks up the base
table for data. Whereas in the materialized view, the base query
result is saved in a separate place, like a normal table. Everytime
you query the maetrialized view, it will only get you result image
based on last refresh. Meterialized views are meant for speeding
summary report queries that deal with historical data. It does
require database space like normal tables.
- Raj Kathamuthu
--- In email@example.com, "Goulet, Dick" <dgoulet@v...> wrote:
> Materialized view is the OLD name for a snapshot. Replacing your
views with MV's would improve performance, but changes to the
underlying tables of the original view may not be visible in the MV,
depending on how they are set up with regards to refreshing
themselves. May become more of a pain than a benefit.
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
> -----Original Message-----
> From: Tripathi, Tushar Mani [mailto:tushar.mani.tripathi@c...]
> Sent: Tuesday, March 02, 2004 10:52 AM
> To: firstname.lastname@example.org
> Subject: PeopleSoft DBA Forum Materialized Views
> Is it a good practise to use Materialized view over view in Oracle.
> We have build lot of customized view and would like to create
> to improve performance.
> The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
> Yahoo! Groups Links