Analyzing queries with set statistics plancost

set statistics plancost simplifies query analysis. It displays the estimated values for logical I/O, physical I/O, and row counts compared to the actual ones evaluated at each operator, and reports on CPU and sort buffer cost.

See “set statistics plancost” in Chapter 6, Ensuring Stability and Performance” in the Migration Guide.