
79
4
Materialized Views and Query Rewrite
This chapter is divided into three parts covering materialized view syntax,
different types of materialized views, and finally tools used for analysis
and management of materialized views. We will examine the use of mate-
rialized views in data warehouses, identify their benefits to general data-
base performance, and discuss the very basics of query rewrite. Use of
materialized views is a tuning method in itself. There are various ways
that materialized views can be built, performing differently depending on
circumstances and requirements.
4.1 What Is a Materialized View?
A materialized view can be used to ...