Introduction to Oracle Materialized Views used for Performance Tuning
The Oracle database contains a number of features designed to deliver improved performance for types of database access that
have become more popular. Improvements in the cost-based optimizer, as described in the previous module, have increased the ability to use
the star schemas of the data warehouse.
Materialized views are another feature designed to improve the performance of the data warehouse.
Data Warehouse: A type of database that is used for analysis of data. The data warehouse frequently has a different type of structure a
star schema as opposed to a standard normalized schema and is also frequently separate from an organization's transaction database.
In this module, you will learn how to:
Describe a materialized view and its uses
Describe the parameters and what they mean in the
CREATE MATERIALIZED VIEW command
Write Structured Query Language (SQL) to create a materialized view that stores summary data
Describe the conditions and types of indexing for materialized views
Check the status of a materialized view and fix it
Describe what conditions allow for query rewriting
Describe the function of the
Materialized views can also be used for other purposes, such as providing snapshot replication for distributed sites or downloading extracts in a mobile computing environment.
In the next lesson, we will discuss materialized views and their uses.