what is use of materialized view in oracle

SELECT * FROM emp@remote_db eWHERE EXISTS (SELECT * FROM dept@remote_db d WHERE e.dept_no = d.dept_no) [refresh [fast|complete|force][on demand | commit][start with date] [next date][with {primary key|rowid}]]The refresh option specifies: The refresh method used by Oracle to refresh data in materialized view Whether the

Original Url:http://lzfhope.blog.163.com/blog/static/636399220124942523943/?suggestedreadingwumiiEnvironment Oracle 10g 10.2.0.4 Linux 64See Oracle's own documentation-sql reference for a large and professional look.To tell the truth, Oracle needs to learn too much, each looking past, it is too cumbersome.So if you can have an overview of

An Introduction to materialized views: Http://blog.csdn.net/tianlesoftware/article/details/4713553 On Lao Yang's blog, I saw some column descriptions, sorted them out, and reproduced them. The original Article link is as follows: Rapid refresh of materialized views (1) Http://yangtingkun.itpub.net/post/468/14245 Rapid refresh of

Recursive calls0 db Block gets3 Consistent gets0 physical Reads0 Redo Size379 Bytes sent via sql*net to client499 bytes received via sql*net from client2 sql*net roundtrips To/from Client0 Sorts (memory)0 Sorts (disk)1 rows processedSql> set Autotrace offFor OLTP systems where things are frequent, use materialized views as little as possible.Setting ParametersThe following parameters can be set at the data

, the limitations of the fast refresh of the three materialized views are very different, while others are not very significant. http://baike.baidu.com/view/3208435.htm My understanding is a view of the data stored in the table, he is only nominally called the

Label:Original address: http://www.cnblogs.com/Ronger/archive/2012/03/28/2420962.html Materialized views are a special physical table, and the materialized view is relative to the normal view. The normal view

effect when multiple tables are created, and the original table will have two more types of view charts: Mlog$_table_name and Rupd$_table_name) Complete: Refresh all. Equivalent to re-executing the query statement that created the view. Force: This is the default data refresh method. When you can use fast mode, the d

Materialized views are similar to indexes in many aspects: materialized views are used to improve query performance, while materialized views are transparent to applications, adding or deleting materialized views does not affect the correctness and validity of SQL statements in applications.

Materialized views are a special physical table. ldquo; Materialized rdquo; (Materialized) views are relatively common views. A common view is a virtual table, and its application has many limitations, Materialized views are a spe

Create materialized view [view_name] refresh [Fast|complete|force] [on [Commit|demand] | Start with (start_time) next (next_time) ] as {Create a query statement for materialized views} These are the common syntax for Oracle to create materialized views (

been performed. 6, Master table reorganization. 7, materialized view registration failed at the master site. 8. Incorrect conversion of a materialized view log from ROWID to primary key. 9. Manual deletion of sys.slog$ entry for the materialized

Materialized View is a special physical table. The Materialized view is relative to a common view. A common view