Find a Table in Execution Plan – SQL in Sixty Seconds #151

Finding the table in a huge execution plan is always a nightmare and often people go for third party tool for help. I have also seen experts going through the XML execution plan to find the occurrence of the table. While all other methods work fine, let us see how easily we can find this in an SSMS. Let us learn how to find a table in an execution plan.

Let us assume that this is your query.

SELECT *
FROM [Sales].[Orders] o
INNER JOIN [Sales].[OrderLines] ol ON o.OrderID = ol.OrderID

Now let us enable the execution plan when you run the above query against the sample database WideWorldImporters. Here is the blog post which discusses how to enable an execution plan. Now once you have an execution plan, right-click on it and select the Find Node.

Do you want me to create a video on this topic, if yes, please let me know in the comments section and I will be happy to build a video on this topic? You can subscribe to my YouTube Channel where I talk about SQL in the Sixty Seconds. I am very confident that you will like the videos.

Let me know what you think of this video. Here are my few recent videos and I would like to know what is your feedback about them.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Menu
Exit mobile version