Execution Plan Types

Question

Execution Plan Types

Grant Fritchey

SSC Guru

Points: 398882
More actions
February 11, 2020 at 12:00 am

#3715247

Comments posted to this topic are about the item Execution Plan Types
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 1

Shocklingly enough, I got this one right.

Yeah, I know, I know. But I'm helping to keep an eye on the site with Steve on sabbatical. Part of this means I'm answering (or not answering as the case may be) all the Question of the Day. Then I comment on my answers (or lack thereof), ta-da, instant monitoring.

Honestly, I expect one or two objections to this one (the question, not my answer).

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 2

Your article https://www.scarydba.com/2009/02/25/three-kinds-of-execution-plans/ states

" You read that correctly, three kinds of execution plans. "

??

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

I too did 3, I was expecting XML, Graphical and Text as the answer

Dmitriy Bonin SSC Enthusiast Points: 150 More actions · Answer 4

I expected to see the option with number 2 for serial and parallel plan types. Could be that I just misunderstood the question.

George Vobr SSCrazy Eights Points: 9996 More actions · Answer 5

Scary but interesting question, thanks Grant. At first I thought that all possible answers could be considered correct. After a moment of despair, I found a hint for the right solution in this useful book.

NBSteve SSCarpal Tunnel Points: 4055 More actions · Answer 6

Ha, I was going to say 3 too, same rationale as anthony.green. Then I saw Grant Fritchey was the author, and I've read enough of his recent posts to know exactly what he was intending 🙂

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 7

NBSteve wrote:

Ha, I was going to say 3 too, same rationale as anthony.green. Then I saw Grant Fritchey was the author, and I've read enough of his recent posts to know exactly what he was intending 🙂

ditto... of course I was just glad that I didn't have to mentally parse 2 pages of code today just to figure out what the question was asking. 😉

Stewart "Arturius" Campbell SSC Guru Points: 72624 More actions · Answer 8

Very interesting question, thanks Grant

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

BartekR SSC Veteran Points: 250 More actions · Answer 9

Tricky one. If it were not Grant who asked the question I would go for three (estimated, actual and live - as in SSMS), but I've seen him talking about just one execution plan - estimated, so I got this one right.

SQLWinther SSCertifiable Points: 6294 More actions · Answer 10

Tricky! I guessed 3, estimated, actual and live

/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform