314: Materialized Views - a Re-view
Carl Dudley , University of WolverHAMPTON    Biography

Objectives: How materialized views can enhance query performance by taking advantage of query rewrite features
Examine of the pros and cons of the different refresh methods that can be employed
How to employ materialized views in areas outside of their normal usage
Abstract: Organisations have databases growing at a rapid rate. The sheer size of the tables can give rise to poor performance, making business data analysis difficult. Oracle is able to use materialized views. These are database objects that contain frequently queried summary information. Query performance can be vastly improved when these views are used instead of the tables. When referencing a base table, the query is automatically re-written by the optimizer against a much smaller data set the materialized view. The talk will discuss the build of a test-case scenario which shows the effectiveness of materialized views in terms of query performance. The re-write capability will be investigated along with the issues of view maintenance, nested views and refresh options. Oracle tools that assist with materialized view design and maintenance will be demonstrated along with some novel uses of materialized views in such areas as intergrity checking, flashback table, and online table redefinition

Audiernce Focus: DBA
Expertise: Intermediate
Track: Database
Date: Monday, April 14, 2008
Time: 1:00 PM - 2:00 PM