If Showplan Operator
The If operator carries out conditional processing based on an expression. If is a language element.
.gif "If language element icon")
Graphical execution plan icon
See Also
Tasks
How to: Display an Actual Execution Plan
Concepts
Logical and Physical Operators Reference
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)
Using IF...ELSE