Interested to Buy Any Domain ? << Click Here >> for more details...
what is Materialized Views?
- 2 Answers
- 7465 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vr
A materialized view is a database object that contains the results of a query. For example, it may be a local copy of data located remotely, or may be a subset of the rows and/or columns of a table or join result, or may be a summary based on aggregations of a table's data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends
What is execution plan?
What is the main difference between inmon and kimball philosophies of data warehousing?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
What are the data types present in bo? What happens if we implement view in the designer n report?
Explain vldb?
Explain the definition of normalized and denormalized view and what are the differences between them?
How can we run the graph? How can we schedule the graph in unix?
How to export mappings to the production environment?
What are templates in which way it is help full?
Why is dimensional normalization not required?
Explain what is the difference between power center & power mart?
Teradata 
