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:7/29/09 3:03 PM


Details


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




User comments

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

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,


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? Please add it below. Your name and tip will appear at the end of the document text.
Your name:
Your email:
Hide my email address
Verification code:
Enter the verification code you see above more submitting your tip
Tip:Please limit tips to 1000 characters

Navigation

Social Media

Powered by 10MinutesWeb.com