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
- 13237 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
Can we have multiple application.cfm file in an application?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is the definition of cube in datawarehousing?
What is called data cleaning?
What is Operational Data Store?
Is union transormation is active transformation?
What are the key columns in Fact and dimension tables?
Could any one explain me how to create cascading prompts?
Explain piconet?
What are parallel querys and query hints?
What is dimensional modelling?
What is incremintal loading?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
Explain what are the tasks that loadmanger process will do?
