How Materialized Views are linked with Oracle DataWare
house?
Answer / 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 |
Explain differences between star and snowflake schemas?
What is metadata in context of a datawarehouse?
What is the purpose of cluster analysis in data warehousing?
Why denormalization is promoted in universe designing?
What are the different methods of loading dimension tables?
How to create diff. Types of templates?
what is the use of surrogate key in businessobjects
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
What is difference macros and prompts?
Explain difference between e-r modeling and dimentional modeling?
How can you implement many relations in star schema model?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?