Re: internal handling of views

From: Herod <herodt_at_gmail.com>
Date: 5 Aug 2006 20:26:57 -0700
Message-ID: <1154834816.958562.168780@i3g2000cwc.googlegroups.com>

A "view" can simply be thought of as a stored query. Oracle simply runs the underlying SQL that is used to make a view.

Then there are Materialized Views (used to be called snapshots) in which oracle takes a query and writes data out that can be retrieved later via query.

Now, materialized views have refresh clauses that can cause the materialized view to be refreshed when a piece of pertanent data in the tables contained in the query that generated the view is changed.

You should check the docs for the particulars. Received on Sat Aug 05 2006 - 22:26:57 CDT