Show TOC

JOIN VIA KEY RANGELocate this document in the navigation structure


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.