Background documentationJOIN VIA MULTIPLE INDEXED COLUMNS Locate this document in the navigation structure

 

JOIN VIA MULTIPLE INDEXED COLUMNS 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 may be combined into a complete index that includes multiple columns.

How Does the System Access the Data?

The database system accesses the rows of the table that is to be linked via this index.