An operation that associates and combines multiple tables.
An operation that combines rows from multiple tables using a shared key. Internally, the optimizer chooses an execution plan from algorithms such as nested loop, hash join, or sort-merge join, with the optimal choice depending on table size and index availability.
© 2026 ITBGM