Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

What is the best way to display an execution plan from SQL Server on SO?

share|improve this question

Screenshot sounds fine, or ASCII if you can get away with it.

Don't do what this guy did, at any rate:

Still laughing about that one.

share|improve this answer
Wow... Not just a screenshot of an ASCII-diagram, but a screenshot of a Word-mangled ASCII-diagram... – Shog9 Oct 22 '09 at 18:46
Ah, that was what I was just looking for as a [bad] example. – squillman Oct 22 '09 at 18:46
Excellent example Jeff. – Troggy Oct 22 '09 at 18:47
My first thought when I saw that was, "How'd he get Times New Roman" to show up, and then it was, "Why is that squiggly line there." And finally: /facepalm. – George Stocker Oct 22 '09 at 18:54

I would say screen cap, or a link to a page that displays it. If it's not an overly complicated execution plan you might also be able to just describe it or list the components in text.

share|improve this answer
A screen cap with borders, drop-shadows, and hand-drawn circles. – Shog9 Oct 22 '09 at 18:45
But of course. Red circles. – squillman Oct 22 '09 at 18:51
Don't forget the glittering unicorns! – gnostradamus Oct 22 '09 at 18:53
I don't think a screen cap would cut it- the plans can get fairly large. – Joel Coehoorn Oct 22 '09 at 20:01

I don't know about screen shots: the plans can get large. Sql Server has an xml option for query plans. I'd go with that:

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .