13. Creating Indexes : Creating Indexes : Secondary Indexes with Joins
 
Share this page                  
Secondary Indexes with Joins
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.