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.

See Also

Tasks

How to: Display an Actual Execution Plan

Concepts

Using Cross Joins

Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)