There’s a very old saying, “When you find yourself in a hole, stop digging.â€
And my evidence today is:
That’s certainly not the hairiest execution plan I’ve seen. In some ways, it’s not all that horrible. But it sure is evidence that someone was down in a hole and they were working that shovel hard.
If you’re interested, most of the operators are scans against a table variable that’s 11 million rows deep. There are also table spools chugging away in there. And the select statement only returns 1500 rows.
Please, stop digging.
On the bright side, it’s a worthy addition to Brent’s collection of execution plans as art.
Ha! Yeah, it’s somewhat “pretty”
[…] There’s a very old saying, “When you find yourself in a hole, stop digging.†And my evidence today is: That’s certainly not the hairiest execution plan I’ve seen. In some ways, it’s not all that horrible. But it sure is evidence that someone was down in a hole and they were working that shovel hard. […] Database, Performance Read the original post on Home Of The Scary DBA… […]
It looks like a double helix DNA genome!
I smell recursion…
That is a work of art! I wonder what the TSQL looks like … I always stick with the keep it simple stupid (KISS) principle.