Apr 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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

Pinal Dave
SQL Interview Questions and Answers
No Comments

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)

Execution Plan, SQL Performance, SQL Server Management Studio, SSMS
Previous Post
How to Capture Deleted Rows Without Trigger? – Interview Question of the Week #297
Next Post
How to Add Constraint With No Validation? – Interview Question of the Week #299

Related Posts

Leave a Reply

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 88 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Comprehensive Database Performance Health Check

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

SQL Server Performance Tuning Practical Workshop

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.