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.