What are materialized views?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What are materialized views?
Rating:
Materialized views are local copies of a master object. This master object can be a table or another materialized view. The copies can be complete or partial. Materialized views help in executing the queries faster because the queries fetch data from the local copies, instead of relying on the master object. An optimizer dynamically rewrites the queries issued by a user to the closest matching query in the memory. This enables a materialized view for the already existing query in memory to be used instead of a master object. Since the queries are dynamically rewritten, the entire process becomes transparent to the user.
Rating:
Was this information helpful?
Other articles
- Study tips for Oracle test 1Z0-033.
- What is alert log?
- What is ONLINE option?
- What is an Oracle Net listener?
- What are conventional path loads?