JOIN VIA MULTIPLE INDEXED COLUMNS is a search strategy of the SQL optimizer.
When Can the System Use This Strategy?
The database system can use this search strategy if the join columns may be combined into a complete index that includes multiple columns.
How Does the System Access the Data?
The database system accesses the rows of the table that is to be linked via this index.