Entering content frame

Background documentation JOIN VIA INDEXED COLUMN Locate the document in the library structure

JOIN VIA INDEXED°COLUMN is a search strategy of the SQL Optimizer for joins.

This search strategy can be used if an index was created for the join column, and this index only contains this one column.

The rows of the tables that you want to join are accessed through the index of the join column.

See also:

Search strategies for Joins

List of All Search Strategies

 

Leaving content frame