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
- 13199 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 dimensional modelling?
What is the goal of optimizer?
Can we start and stop single session in concurent bstch?
Explain what are the various transformation available?
Explain the different types of data warehousing?
What are the different types of segments?
Can you pass sql queries in filter transformation?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Explain is olap databases are called decision support system true/false?
How to create diff. Types of templates?
What are the different methods of loading dimension tables?
What is Discover and Execute in XMLA?
What is a source qualifier?
What is Active Datawarehousing?
What is a real-time data warehouse?
