Joinrelated
Joinrelated is a term encountered in discussions of relational databases and query optimization to describe a relationship between two relations that can be connected by a join predicate. It is not a formal, universally standardized concept, but rather a convenient shorthand used in some texts, notes, and discussions to reason about how data items might be combined through joins.
Definition and interpretation can vary, but a common interpretation treats two relations as joinrelated if there
Applications of joinrelated reasoning include query planning and optimization. By analyzing which relations are joinrelated, a
Limitations include the lack of a formal standard definition. Because “joinrelated” is not universally defined, its
See also: join, join predicate, join graph, query optimization, foreign key.