Cross Join
Short Description
Cross Join joins each row from the first input with each row in the second input
Detailed Description​
Each row from the first input is joined with each row in the second input and the combined output passed onto the next step.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.