SQL Server Execution Plan Icons

<< Use Microsoft DB2 OLEDB Provider On Non-Enterprise SQL Server Editions | Home | Handy SQL Server Function (you may not have known about) >>

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.

Feedback

# 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.

8/27/2010 2:37 PM | Michael J Swart

# 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.

8/30/2010 12:04 PM | Rob Volk

Comments have been closed on this topic.

TRUNCATE TABLE master..sysdatabases

My Links

Article Categories

Archives

Post Categories

SQL