A join where all of the rows that are joined reside in the same database partition. See also collocated join.