WinSQL » Knowledge base

Document information

Document ID:774
Subject:What is a materialized view in Oracle
Creation date:7/29/09 3:03 PM
Last modified on:12/11/18 3:18 PM


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, known 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).

User comments

Posted by swetha on 10/3/09 6:56 AM

Hi, why we are using query rewrite in matearialize views? it is transparent to the applic means , query rewrite means we can rewrite i.e. while we are using matearialized view steps are, create mateariazed view e.g.mt1 is the name of matearialized view, then in applic select table access some syntax without writing the entire query in select stmt only putting matearialized view name and select with table access we get the result whatever is there in matearialized view query i.e. uselful only while query rewrite is true, i.e. whatever i uderstand the concept but my dbts are above 2 questions,pls let me know, bye,

Posted by suresh pareth on 7/29/09 3:04 PM

Difference between view and materialized view is that the former does not hold any data

Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users?

Important: This area is reserved for useful tips. Therefore, do not post any questions here. Instead, use our public forums to post questions.


Social Media

Powered by