...
The names describe their uses. This is especially useful for the fact-fact join (query 82 in the TPC DS benchmark).
SMB Join across
...
Tables with
...
Different Keys
If the tables have differing number of keys, for example Table A has two 2 SORT columns and Table B has 1 SORT column, then you might get an index out of bounds exception.
The following query results in an index out of bounds exception because emp_person let us say for example has one 1 sort column while emp_pay_history has 2 sort columns.
...