what is Materialized Views?
Answers were Sorted based on User's Feedback
Answer / rameshbabu.katikireddy
In literature on data warehousing are created in Oracle using a schema object called a materialized view. Materialized views can be used to perform a number of roles, such as improving query performance or providing replicated data, as described below.
In data warehouses, materialized views can be used to recompute and store aggregated data such as sum of sales. Materialized views in these environments are typically referred to as summaries since they store summarized data. They can also be used to recompute joins with or without aggregations. So a materialized view is used to eliminate overhead associated with expensive joins or aggregations for a large or important class of queries.
Posted by
Rameshbabu.katikireddy
Time:jan.11.2012,6:20pm
Contact09767696346
Karimnagar
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / vr
A materialized view is a database object that contains the results of a query. For example, it may be a local copy of data located remotely, or may be a subset of the rows and/or columns of a table or join result, or may be a summary based on aggregations of a table's data.
Is This Answer Correct ? | 0 Yes | 0 No |
What we will do with the universe for faster process?
what is the diffrence between psa and idoc
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
How can you implement many relations in star schema model?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
What is a data warehousing?
What is is a star schema?
What is vldb(very large databases)?
What are the different types of data warehouses?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Explain in detail abt measure objects? And what is the use of it? How to create it?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?