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
- 13109 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / mallika
In data warehouses, you can use materialized views to
precompute and store aggregated data such as the sum of
sales.
Materialized views are often referred to as summaries,
because they store summarized data. They can also be used
to precompute joins with or without aggregations.
A materialized view eliminates the overhead associated with
expensive joins and aggregations for a large or important
class of queries
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Could any one explain me how to create cascading prompts?
What is a relationship?
What are the various transformation available?
Explain the difference between filter and conditin?
What is drill-through?
What are aggregate fact tables ? why they are needed? give an example
What is DTM session?
What is the difference between junk dimension and degenerated dimension?
Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 Answers Principal Finance, PT Metalogix Infolink Persada,
What is factless fact schema?
What is the difference between a W/H and an OLTP application?
What is difference between Mapplet and reusable transformation?
Teradata 
