While the performance of joins is already improved with min-max indexes, further improvement can be made by adding secondary indexes.

This feature is best used when at least one table of the join is much smaller than the others. The indexes should be created on some of the bigger tables, on one or more of the join keys.