How can Oracle Materialized Views be used to speed up data
warehouse queries?
- 3 Answers
- 12346 Views
- I also Faced
- E-Mail Answers
Answer Posted / sabeena
A materialized view is a database object that contains the
results of a query. They are local copies of data located
remotely, or are used to create summary tables based on
aggregations of a table's data. Materialized views, which
store data based on remote tables are also, know as
snapshots.
A materialized view can query tables, views, and other
materialized views. Collectively these are called master
tables (a replication term) or detail tables (a data
warehouse term).
For data warehousing purposes, the materialized views
commonly created are aggregate views, single-table
aggregate views, and join views.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the difference between datawarehouse and bi?
Difference between cold fusion 5 and cold fusion mx 6?
What are the stages that are required in data warehousing?
What is the function of etl when used in data warehousing?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
What is Star Schema?
Can a dimension table contain numeric values?
What is the limit to the number of sources and targets you can have in a mapping?
Explain how many ways you create ports?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
Explain what are non-additive facts in detail?
Explain what are the various file formats involved in reportnet?
Explain the main differences between star and snowflake schema?
Explain what is full load & incremental or refresh load?
What is type 2 version dimension?
