JOIN VIA KEY RANGE 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 first column of the multiple primary key and the second column is a normal column. With this search strategy, the database system reads the data in the second table within the primary key range sequentially.