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

 

JOIN VIA KEY COLUMN is a search strategy of the SQL optimizer.

When Can the System Use This Strategy?

The database system can use this search strategy for joins where the join column is the only column of the primary key.

How Does the System Access the Data?

The database system accesses the second table in the join directly via the primary key.