RelationalDBDesign RelationalDBDesign 

Performance Tuning   «Prev  Next»
Lesson 1

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 [1]. Materialized views are another feature designed to improve the performance of the data warehouse.

Module objectives

In this module, you will learn how to:
  1. Describe a materialized view and its uses
  2. Describe the parameters and what they mean in the CREATE MATERIALIZED VIEW command
  3. Write Structured Query Language (SQL) to create a materialized view that stores summary data
  4. Describe the conditions and types of indexing for materialized views
  5. Check the status of a materialized view and fix it
  6. Describe what conditions allow for query rewriting
  7. Describe the function of the DBMS_OLAP and DBMS_MVIEW packages

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.

[1] 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.