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
- 13403 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
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
What is scd1 , scd2 , scd3?
Explain what is the difference between olap and datawarehosue?
Give some difference between oltp and olap.
Explain what is the difference between stop and abort?
What is Sequence clustering algorithm?
What are the different types of join operations?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What is difference macros and prompts?
Explain vldb?
What is the differences between star and snowflake schemas?
How to get the first 100 rows from the flat file into the target?
Explain which columns go to the fact table and which columns go the dimension table?
What is a functional dependency f said to be minimal?
Do you view contain data?
