Materialized View in Oracle:
A materialized view in Oracle is a database object that contains the results of a query. They are local copies of data located remotely, or are used to create summary tables based on aggregations of a table's data. Materialized views, which store data based on remote tables are also, know as snapshots.
It is used for keeping a local copy of the data in a remote database and also to improve the performance in some cases.
Syntax is:
CREATE MATERIALIZED VIEW AS SELECT STATEMENT
A LOG table has to be created corresponding to a Master table to enable FAST REFRESH.
A materialized view in Oracle is a database object that contains the results of a query. They are local copies of data located remotely, or are used to create summary tables based on aggregations of a table's data. Materialized views, which store data based on remote tables are also, know as snapshots.
It is used for keeping a local copy of the data in a remote database and also to improve the performance in some cases.
Syntax is:
CREATE MATERIALIZED VIEW
A LOG table has to be created corresponding to a Master table to enable FAST REFRESH.
No comments:
Post a Comment