Search notes:

Oracle: join

In an SQL statement, a join is part of the from clause. A join is needed to combines rows/records from multiple tables.
The join condition specifies how records from one table are related to the records of the other table.
Joins are typically used to query master-detail table relationships.
An essential task of the optimizer is to find an execution plan that executes the joins in an order and with join-methods to reduce the database resources and time needed to execute the statement.
This order can be influenced with the leading (and somewhat also the ordered hint.

TODO

Partial partition wise joins.

See also

Equijoins, hash joins, semi joins, anti joins, outer joins and self joins.
Bitmap join indices
The leading hint allows to specify the order in which tables are accessed when joining them.
cross apply

Index