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
- 13124 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
For faster process, what we will do with the universe?
What is the difference between olap and oltp?
What is Discover and Execute in XMLA?
Explain how to get the first 100 rows from the flat file into the target?
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 reference cursor?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What is the difference between filter and lookup transformation?
List any five applications of data warehouse.
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
How can you implement many relations in star schema model?
Explain difference between e-r modeling and dimentional modeling?
What is vdl (view definition language) explain?
How to get the first 100 rows from the flat file into the target?
What is a staging area? Do we need it? What is the purpose of a staging area?
