how to understand the flow showplan_text stmt

pts.
Tags:
SQL Server
hai everybody, desperately i need to understand the execution plan and flow of joins or any other queries using 'set showplan_text on'. i am getting the output, but the iam not getting the flow i.e. which part is executed first, from bottom or up [ how to read the lines which are sepearted by ||...] in which joins are executed.. so many.. can anyone show me some light FOR EG: |--Nested Loops(Left Outer Join, OUTER REFERENCES:([c].[DEPARTMENTID])) |--Table Scan(OBJECT:([sample].[dbo].[GRADE] AS [c])) |--Nested Loops(Inner Join) |--Table Scan(OBJECT:([sample].[dbo].[employee] AS [A]), WHERE:([A].[departmentid]=[c].[DEPARTMENTID])) |--Table Scan(OBJECT:([sample].[dbo].[department] AS [B]), WHERE:([B].[departmentid]=[c].[DEPARTMENTID]))

Answer Wiki

Thanks. We'll let you know when a new response is added.

It should start at the bottom.

It is much easier to read the execution plans if you display them in graphical mode.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following