15.00 - Materialized Join Index - Teradata Database

Teradata Database Design

Teradata Database
Release Number
Content Type
User Guide
Publication ID
English (United States)

Materialized Join Index

The materialized logical join index rows are the following:


Note that the information for the null customer is not included in this join index because it was defined using an inner join.

Note: Join indexes are not limited to binary joins: like any other join, they can be defined on joins involving as many as 128 tables.