The materialized logical join index rows are the following:
| Fixed Part | Repeated Part | |||
|---|---|---|---|---|
| CustKey | Name | Status | Date | Comment |
| 100 | Robert | S | 2004-10-01 | big order |
| S | 2004-10-05 | credit | ||
| 101 | Ann | P | 2004-10-08 | discount |
| 102 | Don | S | 2004-10-01 | rush order |
| D | 2004-10-03 | delayed | ||
The information for the null customer was defined using an inner join, and therefore is not included in this join index.
Join indexes can be defined on joins involving up to 128 tables.