JOIN VIA INDEXED COLUMN is a search strategy of the SQL optimizer.
When Can the System Use This Strategy?
The database system can use this search strategy if an index was created for the join column and this index only contains this one column.
How Does the System Access the Data?
The database system accesses the rows of the table that is to be linked via the index of the join column.