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

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

In the second table, the data is read sequentially within the primary key range.

See also:

Search strategies for Joins

List of All Search Strategies