Limit Number of Join Rows

Performance impact: Variable

Larger numbers of join rows decrease performance. You can limit the number of join rows and the number of tables joined by controlling the join condition.

For example, use only equality conditions that map one row from one table to one or at most a few rows from the other table.