JOIN VIA KEY COLUMN

JOIN VIA KEY°COLUMN is a search strategy of the SQL Optimizer for joins.

This search strategy can be selected if the first join column is the only column of the primary key and the second column is a normal column.

The second table can be accessed directly with the primary key.

See also:

Search strategies for Joins

List of All Search Strategies