Returns all right rows and matching left rows.

Normalization requiring atomic field values.

Database copy primarily serving read operations.

Index containing multiple columns.

Returns matched and unmatched rows from both sides.

Normalization eliminating partial dependencies.

Delay between primary and replica data updates.

Index containing all data needed by a query.

Produces combinations of every row from both datasets.

Normalization eliminating transitive dependencies.