© Copyright IBM Corp. 2002 15
Chapter 2. DB2 UDB’s materialized
views
In this chapter we provide an overview of DB2’s materialized views, and offer
guidelines for creating, updating, and tuning them.
The topics covered include:
Materialized view overview
Materialized view CREATE considerations
Materialized view maintenance considerations
Loading base tables (LOAD utility)
Materialized view ALTER considerations
Materialized view DROP considerations
Materialized view matching considerations
Materialized view design considerations
Materialized view tuning considerations
Refresh optimization
Materialized view limitations
Replicated tables in nodegroups
2
Get DB2 UDB's High-Function Business Intelligence in e-business now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.