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
|--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]))
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!