 |
 |
 |
 |
 |
||||||||||||||||
 |
 |
 |
|
|||||||||||||||||
 |
|
|||||||||||||||||||
 |
|
|||||||||||||||||||
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
||||
 |
 |
 |
 |
 |
|
|||||||||||||||
 |
 |
 |
|
|||||||||||||||||
 |
|
|||||||||||||||||||
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Document information
DetailsA 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 commentsPosted 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 documentDo 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. | ||||||||||||||||||
