JOIN VIA MULTIPLE KEY COLUMNS is a search strategy of the database system for joins.

The database system can use this search strategy if the join columns can be combined to the key from the new table consisting of multiple columns. With this search strategy the database system accesses the relevant table rows in the new table directly.