JOIN VIA KEY RANGE 
JOIN VIA KEY RANGE is a search strategy of the SQL optimizer.
When Can the System Use This Strategy?
The database system can choose this search strategy if the joined columns are the first n columns of the key (n < number of key columns).
How Does the System Access the Data?
The database system reads the data in the second table sequentially within the primary key range.