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.
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.
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.