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
How to pivot row data using informatica?
Where the applications and where
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
What are the methodologies of data warehousing?
How many project sources we can create in metadata?
How we are using this function?
What are the key features of chameleon that separates it from other algorithms?
What is the difference between Datawarehouse and OLAP?
What is the advantages data mining over traditional approaches?
What is a data profile?
what are the other factors of the database on which the loading performance depend?
Explain what are the advantages data mining over traditional approaches?
What is scd1 , scd2 , scd3?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?