How can Oracle Materialized Views be used to speed up data
warehouse queries?
- 3 Answers
- 12330 Views
- I also Faced
- E-Mail Answers
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 meta data and system catalog?
What is the difference between power center & power mart?
Explain the main difference between inmon and kimball philosophies of data warehousing?
Explain the versions of reportnet?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
what are the others of "bad files" and "discard files" when using sql*loader?
Explain what are the modules in power mart?
How to limit the max no of rows retrieved in the report?
What are algorithms provided by Microsoft in SQL Server?
Define data warehouse?
The same tier?
How to export mappings to the production environment?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
What are situations where snowflake schema is better than star schema when the opposite is true?
What is static and local variable?
