Oracle Materialized Views are a revolution in Oracle technology. Using Materialized Views with Oracle's automatic query rewrite, the Oracle professional can pre-join tables and pre-summarize critical information for lightening-fast SQL response time. This is an advanced reference for the senior Oracle professional. This book is not just theory, but includes numerous, practical examples that illustrate the key steps in using Materialized Views. Through these detailed examples, we show you step-by-step how to design, create, and maintain Materialized Views. We also include practical guidelines for setting refresh intervals that will quickly hypercharge your Oracle performance. Chris Lawson is an expert on Oracle performance and leverages his substantial background in performance tuning to give you a comprehensive guide to tuning with Oracle Materialized views. Best of all, Lawson provides a ready-to-use code depot that is full of working Materialized View example code. With this exciting guide and its relevant examples, you can quickly build Materialized Views to fit your own environment.

* Learn the steps to create and configure Materialized Views. * See how Query Rewrite improves runtime without any application change. * Learn to find good candidates for Materialized Views. * See how pre-joining tables can hypercharge your Performance. * Pre-summarize information to gain huge savings in run time. * Understand efficient ways to refresh Materialized Views. * See tools for avoiding common mistakes.

About the Author:

Christopher Lawson

Christopher Lawson is a working Oracle consultant and author of the best-selling book The Art and Science of Oracle Performance Tuning.  A noted author and conference speaker, Chris specializes on Oracle performance tuning for data warehouses and financial applications.  With a degree in Electrical Engineering and an MBA from U. C. Irvine, Chris has also served as an Adjunct Professor for the University of Phoenix.  His web site, www.oraclemagician.com, features his many articles and conference proceedings, including his work in Intelligent Enterprise, Exploring Oracle, Oracle Informant, Oracle Internals, IOUG Select, Database Trends & Applications, WritersWrite, and the Northern California Oracle User's Group Journal. Chris lives in Northern California with his wife and two teenage daughters where they cheer-on the San Francisco 49ers and the Oakland Raiders.

Table of Contents:
 

Chapter 1 – Introduction to Materialized Views   The need for pre-aggregation The importance of pre-aggregation The architecture of Materialized Views Determining acceptable staleness     Chapter 2 - Schema denormalization with Materialized Views Understanding dynamic schema denormalization Interrogating existing SQL access patterns Designing overlapping Materialized Views Design considerations for high-update base tables

Chapter 3 – Creating Materialized Views Setting-up query rewrite and instance parameters Oracle syntax examples Materialized view for pre-joining tables Materialized Views for pre-summarizing and pre-aggregating data Specifying the refresh interval   Chapter 5 - Implementing Materialized View Query re-write   System-wide implementation Using query re-write hints   Chapter 6 - Monitoring Materialized Views   Sample Scripts Using the DBMS packages