Answer Posted / rameshbabu.katikireddy
In literature on data warehousing are created in Oracle using a schema object called a materialized view. Materialized views can be used to perform a number of roles, such as improving query performance or providing replicated data, as described below.
In data warehouses, materialized views can be used to recompute and store aggregated data such as sum of sales. Materialized views in these environments are typically referred to as summaries since they store summarized data. They can also be used to recompute joins with or without aggregations. So a materialized view is used to eliminate overhead associated with expensive joins or aggregations for a large or important class of queries.
Posted by
Rameshbabu.katikireddy
Time:jan.11.2012,6:20pm
Contact09767696346
Karimnagar
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain difference between data ware house & data mart?
What is surrogate key? Where we use it?
What are the types of partitioning?
Explain what is the metadata extension?
Explain what are the various transformation available?
What is loop in data warehousing?
What is crass reference table?
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 are the various transformation available?
Explain swot analysis?
Explain the difference between oltp and olap?
Explain what is the difference between stop and abort?
What is the difference between drill through and masterdetail reports?
What are the approaches used by optimizer during execution plan?
What is the difference between power center & power mart?
