How joins are processed

When the optimizer creates a query plan for a join query:

Factors that determine costs on single-table selects, such as appropriate indexing, search argument selectivity, and density of keys, become much more critical for joins.