FULL JOIN = Table Scan because all rows meet the criteria....unless the composite key includes all the values returned in the select statement. In which case, the you would have...