Interested to Buy Any Domain ? << Click Here >> for more details...
How can Oracle Materialized Views be used to speed up data
warehouse queries?
- 3 Answers
- 13401 Views
- I also Faced
- E-Mail Answers
Answer Posted / mallika
In data warehouses, you can use materialized views to
precompute and store aggregated data such as the sum of
sales.
Materialized views are often referred to as summaries,
because they store summarized data. They can also be used
to precompute joins with or without aggregations.
A materialized view eliminates the overhead associated with
expensive joins and aggregations for a large or important
class of queries
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is metadata in context of a datawarehouse?
how much memory space occupied real time project (roughly)?
Define Data Warehousing?
What is the use of incremental aggregation? Explain me in brief with an example?
What is a view as it relates to system modeling?
Difference between cold fusion 5 and cold fusion mx 6?
What is data stream and data adaopter. Is it same are different? Explain?
What are the possible data marts in retail sales?
What is meta data and system catalog?
What are different deliverables according to phases?
Explain the difference between oltp and olap?
What is a core dimension?
Explain me what are data marts?
What are situations where snowflake schema is better than star schema when the opposite is true?
What is cubes?
