Rows of one record in a join: either all the rows the join read for it (with their lookups, built once and reused for every row joined) or a narrower list for one row's join.
Optional
Rows of one record in a join: either all the rows the join read for it (with their lookups, built once and reused for every row joined) or a narrower list for one row's join.