Performing duplicate elimination on both inputs guarantees that the result set produced by the equijoin will not have any duplicates.
no duplicate elimination is performed on the result set produced by the equijoin.