Background documentationJOIN VIA KEY COLUMN Locate this document in the navigation structure

 

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

The database system can choose this search strategy if the first join column is the only column of the primary key and the second column is a normal column. The database system accesses the second table directly via the primary key.