How Materialized Views are linked with Oracle DataWare
house?
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 a primary and secondary actor in use case modeling?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What is type 2 version dimension?
Explain what is cost benefit analysis (cba)?
How to test report in reportnet?
What is partitioning? What are the types of partitioning?
How to pivot row data using informatica?
What is batch processing?
What is meant by metadata in context of a data warehouse and how it is important?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
What are aggregate tables and aggregate fact tables?
Why facts table is useful in representing the data?
What should I have in mind when building olap solution from scratch?
What is data stream and data adaopter. Is it same are different? Explain?
What is the use of incremental aggregation? Explain me in brief with an example?