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 is a functional dependency f said to be minimal?
What are the difference between snow flake and star schema?
How can you clear the cache?
What is the function of surrogate key in data warehousing?
Explain how to export mappings to the production environment?
For faster process, what we will do with the universe?
How to performance tune reports?
What is fact less fact table? Where you have used it in your project?
What is a real-time data warehouse?
Where the applications and where
What is a linked cube?
Explain what is the advantages data mining over traditional approaches?
What is data validation strategies for data mart v?
Explain how to get the first 100 rows from the flat file into the target?
What are target types on the server?