Most Valuable Yak (Rob Volk) Blog

…and other neat SQL Server tricks

SQL Server Execution Plan Icons

Here's a handy link that shows all the query operator icons used in graphical SQL Server execution plans.

Your mission, if you choose to accept it, is to write a query or batch that displays all of them. :)

This tape/disk/database will self-destruct in 5 seconds.  Good luck, Jim.

Legacy Comments


Michael J Swart
2010-08-27
but there's this one thing...
Sounds like a great challenge. And to guage how difficult it was going to be, I clicked on one of the icons I was unfamiliar with... The first one as it turns out: The Arithmetic Expression ShowPlan Operator.

According to the docs, that Arithmetic showplan operator is not used in SQL Server 2008 R2, 2008 or 2005. :-(

So I'm going to take a crack at another challenge: Hack together a .sqlplan file that is valid enough that SSMS shows as many of the icons as possible.

Rob Volk
2010-08-30
re: SQL Server Execution Plan Icons
I noticed that too, right after I posted of course. I wonder why it's included if it's not used; it's probably a strictly internal sub-operation of other operators. Wonder if there's a trace flag that would display it.