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
- 13053 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 are the advantages and disadvantages of reporting directly against the database?
What are the fundamental elements of the data warehouse?
Is there any default username & pwd for bo designer & supervisor?
How to design file watch jobs?
What is the metadata extension?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Whether dimension table can have numeric value?
What is loop in data warehousing?
How to load the time dimension?
What is normalization, first normal form, second normal form, third normal form?
What is the difference between drill through and masterdetail reports?
What is drill-through?
What is mean by aggregate aware?
What is perform recovery?
What is the limit to the number of sources and targets you can have in a mapping?
