Show TOC

JOIN 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 SQL optimizer.

When Can the System Use This Strategy?

The database system can use this search strategy if the join columns can be combined into the initial part of an index that includes multiple columns.

How Does the System Access the Data?

The database system accesses the relevant table rows within the index range directly.