The If operator carries out conditional processing
The If operator carries out conditional processing in the input and passes on to the next step in the plan.
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.