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
- 13198 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
Explain a relation schema and a relation?
How can you import tables from a database?
What are loops in Datawarehousing?
What is data stream and data adaopter?
Explain the different types of data warehousing?
Explain degenerate dimension table?
Where the applications and where
Is union transormation is active transformation?
Explain what is a view as it relates to system modeling?
What is perform recovery?
What is the difference between star and snowflake schemas?
Explain what is real time data-warehousing?
Explain which are the olap tools available that are supported by oracle?
What is prompt types of prompts?use of prompts syntax of prompt?
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
