manisha Ramchandra Gharat

• Dec 21st, 2006

 

A materialized view 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.A materialized view can query tables, views, and other materialized views. Collectively these are called master tables (a replication term) or detail tables (a data warehouse term).

Swapna

• Jan 10th, 2007

 

A materialized view or snapshot contains the results of a query of one or more tables, each of which may be located on the same or on a remote database. Materialized viwes allows to create replications of tables of remote data with a read-only privillage on the copy. When a materialized view is created, Oracle creates one table and index, and in the same schema of the materialized view.

Sathish Palanivel

• Jul 13th, 2007

 

A materialized view is like a query with a result that is materialized and stored in a table. When a user query is found compatible with the query associated with a materialized view, the user query can be rewritten in terms of the materialized view. This technique improves the execution of the user query, because most of the query result has been precomputed. The query transformer looks for any materialized views that are compatible with the user query and selects one or more materialized views to rewrite the user query. The use of materialized views to rewrite a query is cost-based. That is, the query is not rewritten if the plan generated without the materialized views has a lower cost than the plan generated with the materialized views.

sandeep5580

 Profile Answers by sandeep5580 

• Mar 29th, 2008

 

in addition to te previous posts, unlike a View,which refreshes automatically if the underlying base table data is changed, the data in a  Materialized view needs o be refreshed explicitly with the help of a dbms_job.Thanks.

Ramadevioracle

 Profile Answers by Ramadevioracle 

• Sep 16th, 2008

 

Materialized views are schema objects that can be used to summarize, precompute, replicate, and distribute data. E.g. to construct a data warehouse.

ashish

• Feb 7th, 2012

 

A materialized view have a physical memory where it can store the result of query which are combination in joining of one or more table and view it retrieve a faster result. when we want to refresh the data which are coming from diffrent application so it retrive the fast result. its a benefit of materialized view.

uday bhaskar rerddy

• Apr 19th, 2012

 

Materialized view is the local copy of remote database object.materialized view is the space demanding object and it is read only. At the time of creating the materialized views,we can specify refresh interval and refresh modes.

Refresh intervals represents, how the frequently the materialized view has to be refreshed. Refresh modes are

1. Complete
2. Fast
3. Force
4. Uncommit
5. On demand
6. Differed

Sathish

• Jun 12th, 2012

 

Materialized views are objects that are used in base table that can be Summarized Group, and aggregated with the base table.This materialized views are used in data-ware housing and decision support system.

sachin rasal

• Dec 11th, 2015

 

Materialised view - A table on a disk that contains the result set of a query

Non-materiased view - A query that pulls data from the underlying table

Habib Ali

• May 8th, 2016

 

A view (typically a complex query containing Joins & Aggregates) which stores its result in a DB Table. Can be cached for faster performance. Its highly used in Data Warehousing Environments, but use it carefully as it has lot of restrictions based on clauses and the underlying query