Search My Oracle Blog

Custom Search

05 January, 2007

Building Materialized Views and Indexes

There have been occassions when I have replaced a query on a remote database
with a local materialized view, thus eliminating the frequent fetches across the
network -- only the MV refresh has to go across the network.
Furthermore, it also makes sense to index the MV local. A Materialized View
is, actually (physically) a Table. It can be indexed.
Response time on queries has gone down from 10s of minutes to single minutes
with MVs and then single seconds with the appropriate index(es) on the MVs.

No comments:

Aggregated by orafaq.com

Aggregated by orafaq.com
This blog is being aggregated by orafaq.com

Top 50 Oracle SQL Blogs 2016

Top 50 Oracle SQL Blogs 2016
Top 50 Oracle SQL Blogs 2016