I'm working on execution plan on SQL Server (I'm a junior). I execute a query with a real execution plan and as you can see in the screenshot, the percentage on my join is above 100 % (here 139%).
So I'm wondering if it's normal because it's the first time as I see that.
Thanks for your reply!
Actual execution plan:
That percentage represents the actual number of rows vs what the optimizer estimated.
In this case the optimizer was expecting 11433900 rows but ended up touching 15916500 rows.
15916500/11433900 = 1.39, or, 139%.
Note this section of the execution plan from a query I just ran;
Expected 39 but got 40 instead (40/39 = 1.02 or 102%)
