Background documentationJOIN VIA RANGE OF MULTIPLE INDEXED COL. Locate this document in the navigation structure

 

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

With this search strategy, the database system accesses the relevant table rows within the index range directly. The database system can use this search strategy if the join columns can be combined in the initial part of an index that includes multiple columns.