Problem solve Get help with specific problems with your technologies, process and projects.

Working with materialized views

What are materialized views and when and why do we use them?

What are materialized views and where can we use them (under real-time scenario)?
A materialized view was previously called a snapshot in Oracle. It is a physical table that is based on a query on one or many tables. Materialized views can be used for dynamic data replication or to access data on remote databases without a hit on performance. In comparison to views, materialized views are physical tables and can be refreshed based on some predetermined intervals. In addition, materialized views can use logs to store record changes to quickly refresh the materialized views.

As mentioned materialized views can be used to access remote database tables across database links or can be used to store computed, complex queries within the same database. A practical use of materialized views will be in an operational data store or data warehouse.

You can create indexes on materialized views as well.

Dig Deeper on Using Oracle PL-SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.