Background documentationJOIN VIA RANGE OF MULTIPLE KEY COLUMNS Locate this document in the navigation structure

 

JOIN VIA RANGE OF MULTIPLE KEY COLUMNS is a search strategy of the database system for joins.

The database system can use this search strategy if the join columns can be combined as the initial part of the key of the new table. This key consists of multiple columns. With this search strategy, the database system accesses the relevant table rows of the new table within the key range sequentially.