How Materialized Views are linked with Oracle DataWare
house?
- 1 Answers
- 6072 Views
- Kirloskar, I also Faced
- E-Mail Answers
Answer Posted / satya
Materialized views are schema objects that can be used to
summarize, precompute, replicate, and distribute data. E.g.
to construct a data warehouse.
A materialized view provides indirect access to table data
by storing the results of a query in a separate schema
object. Unlike an ordinary view, which does not take up any
storage space or contain any data.
The existence of a materialized view is transparent to SQL,
but when used for query rewrites will improve the
performance of SQL execution. An updatable materialized view
lets you insert, update, and delete.
You can define a materialized view on a base table,
partitioned table or view and you can define indexes on a
materialized view.
A materialized view can be stored in the same database as
its base table(s) or in a different database.
Materialized views stored in the same database as their base
tables can improve query performance through query rewrites.
Query rewrites are particularly useful in a data warehouse
environment.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is the difference between power center & power mart?
Can you state some of the innovations throughout history?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is the difference between drill through and masterdetail reports?
Explain what is the data type of the surrogate key?
Explain how to export mappings to the production environment?
Start a batches with in a batch?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
How to provide security in frame work manager for a query subject?
Explain datawarehousing?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain what are the methodologies of data warehousing?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
How many project sources we can create in metadata?
What is surrogate key? Where we use it explain with example?
