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
- 13425 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 Discrete and Continuous data in Data mining world?
Explain what is type 2 version dimension?
Where the applications and where
What is latest version of power center / power mart?
What is partitioning? What are the types of partitioning?
What do you mean by static and local variable?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
can anybody mail me the FAQS for hyperion essbase amd planning
Which component has onread method and what it is used for?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What are the tools available for etl?
Can we have multiple application.cfm file in an application?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Why should you put your data warehouse on a different system than your oltp system?
