Entering content frame

Background documentation JOIN VIA KEY COLUMN Locate the document in the library structure

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

 

Leaving content frame