How can Oracle Materialized Views be used to speed up data
warehouse queries?
Answer Posted / svs rajesh
In oracle materialized view carry the carry with them so it
is easy 7 faster to retrieve the data for reporting instead
of goin to the actual database these provide the faster
retrieval of data.
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What are the different types of segments?
Explain what is the limit to the number of sources and targets you can have in a mapping?
Can you state some of the innovations throughout history?
What is Discrete and Continuous data in Data mining world?
what is parallel query?
What is data cleaning? How can we do that?
How can you set the session management?
What is data stream and data adaopter. Is it same are different? Explain?
What is the difference between view filter and report filter?
What are the different types of fact tables used in data warehousing?
What are session timeout and application timeout?
Explain the data type of the surrogate key?
How can we schedule the graph in unix?
What is data analytics in simple terms?
What is meant by metadata in context of a data warehouse?