Execution plans

Question

Execution plans

Viewing 15 posts - 31 through 45 (of 49 total)

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

Mark D Powell SSCarpal Tunnel Points: 4775 More actions · Answer 1

I was going to post the same quote. The execution plan itself is both re-entrant and reusable. The fact each execution also has 'private' areas does not change this fact.

-- Mark D Powell --

Steve Jones - SSC Editor SSC Guru Points: 734564 More actions · Answer 2

My apologies, I was reading execution context and thinking query plan and wrote the wrong words. The intention was to test knowledge of the execution phase of the execution plan, the context.

Everyone has had points awarded back to this time and the question corrected.

Kiara SSCarpal Tunnel Points: 4185 More actions · Answer 3

Steve Jones - SSC Editor (6/28/2011)
My apologies, I was reading execution context and thinking query plan and wrote the wrong words. The intention was to test knowledge of the execution phase of the execution plan, the context.
Everyone has had points awarded back to this time and the question corrected.

Thanks, Steve. You've always been amazingly fair about things like this.

-Ki

M&M SSC-Insane Points: 21700 More actions · Answer 4

Thanks Steve, nice to see the points awarded back 🙂

M&M

Carlton Leach SSCarpal Tunnel Points: 4202 More actions · Answer 5

Cliff Jones (6/28/2011)
Carlton Leach (6/28/2011)
Have you been drinking Steve? :hehe:
Carlton, I think I will reuse your post, thanks.

Certainly Cliff, well played 😉

Carlton.

Kwex Default port Points: 1407 More actions · Answer 6

Kwex

Default port

Points: 1407

June 28, 2011 at 9:06 am

#1345252

Yupee! 2 more points for me 🙂

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

SanDroid (6/28/2011)

Change is Required (6/28/2011)
The showing answer is wrong .
see this for more details
http://msdn.microsoft.com/en-us/library/ms181055.aspx%5B/quote%5D
You should read what you posted closer. What you posted clearly states that
Query Plan + Execution Context = Execution Plan
And Execution Context <> reentrant
According to what you posted the answer is right.
"showing answer is wrong" = wrong answer

That logic does not hold true for this type of question though. Since an execution plan contains both the query plan and the execution context, only one of those sub features has to include reentrant for the execution plan to also be re-entrant. Just because an Execution Plan is reentrant does not mean however that an execution context is re-entrant. It is a simple 'OR' operation and not an 'AND' operation. Properties of subcontainers transfer to parent container but properties of parent container do not transfer to subcontainers.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Steve Jones - SSC Editor (6/28/2011)
My apologies, I was reading execution context and thinking query plan and wrote the wrong words. The intention was to test knowledge of the execution phase of the execution plan, the context.
Everyone has had points awarded back to this time and the question corrected.

Thanks Steve.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 9

Steve Jones - SSC Editor (6/28/2011)
My apologies, I was reading execution context and thinking query plan and wrote the wrong words. The intention was to test knowledge of the execution phase of the execution plan, the context.
Everyone has had points awarded back to this time and the question corrected.

thanks!!!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

Lisa Phillip SSCrazy Points: 2991 More actions · Answer 10

I think re-entrant is also a correct answer. Looking at books online you find the context described as reentrant as well. We should be awarded the points for a correct answer.

FargoUT SSC Eights! Points: 853 More actions · Answer 11

Note to self: read the actual question on the site rather than the question in your RSS feed. I didn't even notice the update to the question until after I had selected the wrong answer. 🙂

Rafael Krisller Right there with Babe Points: 737 More actions · Answer 12

Mistakes happen, nobody is perfect.

But apology is noble.

Thanks Steve!

c00578 SSChasing Mays Points: 619 More actions · Answer 13

Another good question. It appears as if the Execution Plan is reusable and re-entrant however the Execution Context is only reusable.

The devil is in the details.

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 14

Rafael Krisller (6/28/2011)
Mistakes happen, nobody is perfect.
But apology is noble.

😎 i agree

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

db4breakfast Ten Centuries Points: 1097 More actions · Answer 15

Great question. I've to do more research to fully understand it.

Thanks!

--------------------------------------------------------------------------------------
Hai Ton
My Db4Breakfast blog.