What is EDGE in SQL Server Execution Plan? – Interview Question of the Week #298

Question: What is EDGE in SQL Server Execution Plan?

Answer: It is the arrow or the line which goes from one operator to another operator.

What is EDGE in SQL Server Execution Plan? - Interview Question of the Week #298 edge1-800x435

Yes, it is true. Not many people know that in the execution plan we have a very important operator that contains the details about the rows processed by operators.

Here is how you can validate this one. First go to SSMS, SQL Server Management Studio, and run any query keeping the actual execution plan on. In this blog post, I have written three different ways you can enable the actual execution plan.

Now go to the Graphical Execution Plan and select on the arrows going from one operator to another operator. Now right-click on it and go to the properties of it and on the right side, you will see the property window with the label EDGE on it. So there you go, the official name of the arrow is EDGE.

What is EDGE in SQL Server Execution Plan? - Interview Question of the Week #298 edgeinss

Did you know this one? If you know any other such interest fact, please reach out to me on Twitter and I will be happy to blog about it with due credit to you. You can also reach out to me on LinkedIn and YouTube.

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

, , ,
Previous Post
How to Capture Deleted Rows Without Trigger? – Interview Question of the Week #297

Related Posts

Leave a Reply

Menu