Incorrect arrow width in execution plans (SSMS 17.4)
When showing execution plans in SSMS 17.4, the arrow width is incorrectly based on the ""Number of Rows Read"property (for operaotrs that report it), instead of Äctual Number of Rows". This makes execution plans confusing and misleading when the plan uses scans with pushed-down predicates.
Example:
SELECT * FROM Person.Person AS p
WHERE p.Title = 'xx'
ORDER BY p.EmailPromotion;
On SSMS 17.4, the execution plan shows a thick arrow going into the sort and a thin arrow going out of it. The thick arrow is based on the 19972 rows read withing the clustered index scan operator, but since none of them satisfy the where clause zero rows were actually passed to the sort operator.
Hugo Kornelis
shared this idea
Hello Hugo, the thickness now takes into account the actual rows read by the operator, if available, which as per previous user community feedback, is a more accurate measure of the operator weight in the plan, and it makes it easier to pinpoint problem areas. In some cases, the problem operator had the narrowest line as actual rows is zero, but actual rows read was > 0.
1 comment
-
Hugo Kornelis
commented
Still the same issue on SSMS 17.6