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