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
- 13189 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 an use case?
How can you set the client management?
Explain how are the dimension tables designed?
What is ods (operation data source)?
What is recovering sessions?
What is Cognos script editor?
What is the working process for application.cfm?
Explain bus schema?
What is Sequence clustering algorithm?
What are situations where snowflake schema is better than star schema when the opposite is true?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Can you state some of the innovations throughout history?
Explain what is partitioning? What are the types of partitioning?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
Difference between PowerPlay transformer and power play reports?
