materialized views

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

Posts: 6
Joined: Mon Jun 25, 2012 11:14 am

materialized views

Postby coolboy98699 » Tue Jul 03, 2012 1:25 pm

Sir...i have a bit idea on materialized views...but i don't know the particular advantage to use that?.
In which case do we use them..

Many Thanks

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: materialized views

Postby Tim... » Tue Jul 03, 2012 1:29 pm


1) They are useful to copy remote data locally, improving the performance of queries that would otherwise have to use database links.
2) If you have lots of similar complex queries that perform aggregation of data, you may get benefits by using a materialized view to aggregate the data once, then have the queries posted against the ready prepared data.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:

Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 1 guest