How can Oracle Materialized Views be used to speed up data
warehouse queries?
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
How can you import tables from a database?
What is data mart in data warehouse?
How do we design a universe?
What a static and local variable?
What are loops in Datawarehousing?
How do you define data block size?
Difference between cold fusion 5 and cold fusion mx 6?
Explain why fact table is in normal form?
What are the different types of segments?
Explain the difference between keylokup and joiner?
Database in use is oracle?
What are the mapping paramaters and maping variables?
What are universe requirements?
Explain what is cost benefit analysis (cba)?
Fact table is in normalized or de-normalized form?