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
- 13066 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 are the data types present in bo? What happens if we implement view in the designer n report?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is defined as partial backup?
Explain what are the different types of join operations?
What is difference between query studio and report studio?
How many project sources we can create in metadata?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain why should you put your data warehouse on a different system than your oltp system?
Code the tables statement for a single-level (most common) frequency?
What is analytical or analytic mean?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What are the design methods of data warehousing?
What are the steps to build the datawarehouse?
What are the data marts?
Start a batches with in a batch?
