15.00 - Materialized Join Index - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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.