I'm trying to understand something that is really unexplainable to me. I have a table (let's call it "TableA") with 118 million rows (give or take) and that table is joining another set with 13 million rows. The operator used for the JOIN is a Hash Match.
The problem is that SQL Server is estimating 118 million rows for the Index Scan on my TableA but it say that "Actual Rows" are only 39!
The Index Scan has no predicates so I was expecting the fully 118 millions to be returned, I'm not really baffled by the estimate, what really drives me crazy is the "Actual Count" of 29.
I'm including the anonymized plan in case anybody feels that can understand why this is happening.
By Martin Surasky 16 asked Aug 10, 2015 at 09:16 PM
The query appears to have a
But once that is done, it only has to read 29 rows from
By SQLkiwi ♦ 6.6k answered Aug 11, 2015 at 04:14 AM