15.00 - Materialized Join Index - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
15.00
Content Type
User Guide
Publication ID
B035-1094-015K
Language
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.