WinSQL » Knowledge base
|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|
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).
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
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
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,
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.