How do we implement materialized view?when to use materialized view?
Answer Posted / chanti
A materialized view provides indirect access to table data by storing the results of a query in a separate schema object. Unlike an ordinary view, which does not take up any storage space or contain any data.
A materialized view can be stored in the same database as its base table(s) or in a different database.
Materialized views stored in the same database as their base tables can improve query performance through query rewrites. Query rewrites are particularly useful in a data warehouse environment.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Different qualification between a related rotate toward the sky and isolates look upward?
What are the differences between joiner transformation and source qualifier transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is a router transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
What is the fact table?
How does the aggregator transformation handle null values?
tell me about your project functionality
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How to use procedural logic inside infromatica?
What are the main features of Oracle 8i with context to datawarehouse?
What is the Rank index port in Rank transformation?
How can we delete duplicate rows from flat files?
What is data transformation manager process?