Cross Join Showplan Operator

The Cross Join operator joins each row from the first (top) input with each row from the second (bottom) input.

Cross Join is a logical operator.