Introduction to Materialized Views In Teradata

Materialized views are implemented as join indexes in Teradata. Join in- dexes can be used to improve the performance of queries at the expense of update performance and increased storage requirements. Teradata supports a variety of join indexes including aggregate join indexes, single-table and multi-table join in- dexes, and sparse join indexes. Join indexes can be used in conjunction with base tables if the join index does not completely contain the columns in the select list or the selection condition. A number of techniques used to improve the performance of maintenance for join indexes are described.