Materialized View LogThis is a featured page

When DML changes are made to master table data, Oracle Database stores rows describing those changes in the materialized view log and then uses the materialized view log to refresh materialized views based on the master table. This process is called incremental or fast refresh. Without a materialized view log, Oracle Database must reexecute the materialized view query to refresh the materialized view. This process is called a complete refresh. Usually, a fast refresh takes less time than a complete refresh.

External Links:

SQL Snippets: Materialized Views - Materialized View Logs

Reference:

Oracle® Database SQL Reference 10g Release 1 (10.1) Part Number B10759-01
CREATE MATERIALIZED VIEW LOG


No user avatar
SnippetyJoe
Latest page update: made by SnippetyJoe , Mar 20 2008, 2:13 PM EDT (about this update About This Update SnippetyJoe added external links section - SnippetyJoe

10 words added

view changes

- complete history)
Keyword tags: database materialized view
More Info: links to this page
There are no threads for this page.  Be the first to start a new thread.

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)