How Materialized Views are linked with Oracle DataWare
house?
- 1 Answers
- 6042 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 snowflake and star schema?
How to get the first 100 rows from the flat file into the target?
Explain what is a cube in data warehousing concept?
How to improve session performance in aggregator transformation?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
Explain where do we use semi and non additive facts?
What is ods (operation data source)?
Why denormalization is promoted in universe designing?
What are the fundamental elements of the data warehouse?
What is the difference between metadata and data dictionary?
What is the use of tabular model, tabular sql, tabular reference in real time application?
Explain when do we analyze the tables? How do we do it?
what type of raid setup would you put your tx logs?
What is cfapplication tag?
What is a functional dependency f said to be minimal?
